Tips, tweaks and tidbits from the entity formerly known as DeeMacGee

Monday, January 19, 2009

Altiris Deployment Console Auto-Move PCs - SQL Query - Exceedingly Long Title - Honestly, this is just ridiculous

At some point, fairly soon (I hope), I'll continue the XP Scripted OS Install series... because it's quite fascinating and really rather cool - plus, I'm learning more than I ever wanted to about a) writing documentation, and b) the SOSI procedure itself; its slips, trip-ups and pitfalls make for mind-bending insanity.

In the meantime, I'll offer this: have you ever wanted your Deployment Server Console to organise itself - like Mary Poppins and those kids cleaning up the bedroom with a snap of their fingers? The organisation I work for had severe need of such magic (voodoo), what with all those computers being moved around between floors, buildings, suburbs, etc... so I set to work writing a SQL Query which arranges computers into Console Groups based on IP address/subnet - you provide the appropriately-named Groups, this Query populates 'em. The usual disclaimers apply - run it at your own peril, etc etc etc, but I assume EEEEEEEEEVERYONE will be testing it on a mock-up of their eXpress database before going berko in production. YES? Good.

Since I'm Google's bitch, the Query itself is kept in my Google Docs.
Clickety and enjoy (or fear) - oh, and instructions are enclosed.

0 comments: