[sims] SOLUS3 - Reset 'Install Active' Agents Utility by Matt40k

[Rawns]

@matt40k has been hard at it again and created an awesome little tool for resetting agents in SOLUS3 that have an Agent install status of "Install Active". Discussed in another thread, Capita's own tool seems to have been pulled and no longer available but this does the job just as well.

 

Download: https://s3unlock.codeplex.com/

 

Simply input your server details and connect. If you have any agents with a status of "Install Active", it will list their details and allow you to reset their status:

 

http://i.imgur.com/4kWaSLi.png

 

Once reset (or if you have no devices with an 'Install Active' status), conformation comes in the form of a smiley face:

 

http://i.imgur.com/mZ4rlkG.png

 

Kudos to Matt40k for this.

[matt40k]

Cheers for the PR

[Rawns]

With SOLUS3 on almost everyone's radar these days, this should be a sticky.

[zag]

Cant this be fixed in Solus 3?

[Rawns]

Cant this be fixed in Solus 3?

 

Unfortunately not.

[MrMat]

Wahey! Top work Matt40k, very much appreciated.

[Griff]

Wooop nice work cheers

[sparkeh]

@matt40k I could kiss you. Don't worry I won't. But I could.

[Rawns]

@vikpaw -Could this be a sticky? It's a useful tool and could be useful to anyone on the SOLUS3 boat (which I call the Titanic )

[sparkeh]

@vikpaw -Could this be a sticky? It's a useful tool and could be useful to anyone on the SOLUS3 boat (which I call the Titanic )

Agreed!

 

I can't can totally believe that S3 leaves you in this position.

In my case a PC rebooted unexpectedly during an agent deployment (OS update to blame even though updates are set not to reboot).

'Its ok' I thought 'I'll just reinstall the agent. Hmm I cant...not matter I'll remove the machine...oh wait I can't...in fact I can't do anything!'

 

Ridiculous.

[vikpaw]

Thanks @Rawns for the pointer - where do you get these toys? or at least how do you hear about them.

 

Good job @matt40k - again! - You know what happens to people that make really useful tools and add-ons, they get bought out, have their code stolen and then forced to retire. Still worse things could happen; you might have to go back to doing SIMS support

 

[3s-gtech]

Used this when I first saw it on here, worked very nicely. Cheers!

[matt40k]

Good job @matt40k - again! - You know what happens to people that make really useful tools and add-ons, they get bought out, have their code stolen and then forced to retire. Still worse things could happen; you might have to go back to doing SIMS support

 

Haha, I open source all the small stuff I do so I invite people to steal the code! The idea is you get a bit of a rep. It's just at the moment it appears my rep is being used to demonstrate failings in a certain MIS provider and to be fair, they kinda deserve it. They're not exactly healthy for the open-source community. On the plus side I've got favours all over the place.

[Bluetooth]

Awesome, just saved my life, out of all our machines the heads decided to go tits up, was stuck and CAPITA in all its wisdom seems to be closed today and was closed on Friday, I understand its Christmas time but some of us still have to work.

 

Anyway, tried this util and its sorted out the issue for us, good job mate thank you!

[zag]

How do I fix "Install Queued" errors. The computer does not exist any more.

 

Its been like that for weeks and I can't remove the agent install as the button is greyed out.

 

[Rawns]

You'll need to manually change the agent status value to failed in the SQL database via management Studio.

 

SQL Management Studio -> SOLUS3 DB -> Edit SOLS3.Agents table. Change the Agent Status value to 16.

 

Reopen the UI and the agent will be listed as 'failed' so it can be removed.

Edited January 8, 2014 by Rawns

[zag]

Thanks, that worked!

 

I guess Solus 3 isn't quite finished yet

[matt40k]

Hey @zag and @Rawns - Just updated it to 1.0.1 - basically now allows you to reset Install Queued. Download today from > https://s3unlock.codeplex.com/

[Rawns]

I know this is targeted at agents. What would also be great is the ability to reset deployments with a status of "Rollback in progress" to failed. We've had a few crashed roll backs at various sites resulting in this status.

[matt40k]

You don't want much do you!! I should really go to BETT so I can cash in all these favours lol

[Get2theChoppa]

or remove the named client from the environment and then add again?!... worked for me

[matt40k]

Makes a bit of a mess as it'll generate a new GUID so you'll have 2 records. Also, not sure you can remove it when it's locked install active - basically it's starts installing then the "helpful" person pulls the battery mid install or whatever.

[mtillbrook]

thats fantastic, thank you very much!! It will solve no end of issues for us!

[kevin_lane]

Nice one @matt40k tool is brilliant

[alastair]

Install queued - mmm tricky one.

 

You would have to do a change in SQL Management studio

 

sql query

 

USE solus3_deployment_server

GO

UPDATE solus3.agent

SET agent_status='16'

WHERE agent_status='?'

 

I don't know the status code for install queued, but I'm sure if you look in the solus.agent table find the computer name, then look at the status code, you should be able to use the query above to change the status.