SMS2 Query remote control

[Guest_imported]

The All Systems query in SMS2 used to enable me to remote control clients. This option vanished recently leaving only Distribute Software and Resource Explorer. Any ideas how to get this option back?

 

[Guest_imported]

First you just need to create a new query called "All Systems" In the Edit Query Statement place this SQL script and then click apply see below:

(This is in the show query language box)

select Name, SMSAssignedSites, IPAddresses, IPSubnets, OperatingSystemNameandVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, LastLogonUserName, SMSUniqueIdentifier, ResourceId, ResourceType, NetbiosName from sms_r_system

(you can just cut and paste this if you like) Then you just need to build a new collection called "All Systems" and select this query you created earlier called "All Systems"

This should helkp you to get this back. I hope this helps

Freddie
Sr. Network Consultant
SMS, Exchange, SQL, Win2k and more......

 

[Guest_imported]

Actually I need to make correction on th eabove information I gave you.

You just need to go the "Console Add/Remove box" then click add and look for Systems Management Server click add and select all of the options you want to see in SMS MMC console.