Collection of machines missing client (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003



Message

jpatridge -> Collection of machines missing client (6/20/2008 2:42:48 PM)

Should be an easy one - I'm trying to create a collection that contains all discovered machines that are missing the SMS client. I've tried creating several inverse collections, but I can't seem to get it work. Any suggestions?



jnelson993 -> RE: Collection of machines missing client (6/20/2008 2:51:42 PM)

You're just looking for Client = 0

select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where Client = 0



jpatridge -> RE: Collection of machines missing client (6/20/2008 3:01:15 PM)

I tried that - I entered the criteria "SystemResource.Client is equal to 0", which gave me that exact query language above. I also tried the reverse, "System Resource.Client is not equal to 1". When I click on available values, it only gives me "1", not "0".



jpatridge -> RE: Collection of machines missing client (6/20/2008 3:04:17 PM)

Sorry, forgot to mention that when I enter the query language above, it gives me no results.



bmason505 -> RE: Collection of machines missing client (6/20/2008 3:21:33 PM)

Any chance you just don't have any?



jnelson993 -> RE: Collection of machines missing client (6/20/2008 3:24:09 PM)

I think that's a distinct possibility.  In our massive environment (200K+ machines), I see 5.

If you're doing all you can to install to your discovered devices then this number should really be low.



jpatridge -> RE: Collection of machines missing client (6/20/2008 7:21:38 PM)

I guess I should clarify - we have a lot of machines that are showing up in the console without the client (no site code, "No" under the "client" column). These machines may or may not actually have the client installed - we include the SMS client on our image, and the techs who deploy machines don't always remember to discover a site. So when the machine is discovered by AD system discovery, the client push detects the client is already installed, and won't push it again. So it's still just sitting there not reporting to a site server.

I want a collection of all machines that appear in the console with "No" under the "Client" column so I can do a mass client install to that collection with the "Always install" option checked so we can get all of these machines reporting to a site server.

Sorry if I didn't provide enough details before...



bzschenderlein -> RE: Collection of machines missing client (6/23/2008 9:07:26 AM)

 
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where Client is NULL

something like this?



jpatridge -> RE: Collection of machines missing client (6/24/2008 5:55:21 PM)

That appears to have done the trick - thanks for all the help...



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.203125