Collection of machines missing client

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Collection of machines missing client

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection of machines missing client

Page: [1]

Message

<< Older Topic Newer Topic >>

Collection of machines missing client - 6/20/2008 2:42:48 PM

jpatridge

Posts: 13
Score: 0
Joined: 9/18/2007
Status: offline

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?

Post #: 1

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

jnelson993

Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

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

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to jpatridge)

Post #: 2

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

jpatridge

Posts: 13
Score: 0
Joined: 9/18/2007
Status: offline

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".

(in reply to jnelson993)

Post #: 3

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

jpatridge

Posts: 13
Score: 0
Joined: 9/18/2007
Status: offline

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

(in reply to jpatridge)

Post #: 4

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

bmason505

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline

Any chance you just don't have any?

_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to jpatridge)

Post #: 5

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

jnelson993

Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

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.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to bmason505)

Post #: 6

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

jpatridge

Posts: 13
Score: 0
Joined: 9/18/2007
Status: offline

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...

(in reply to jnelson993)

Post #: 7

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

bzschenderlein

Posts: 4
Score: 0
Joined: 10/10/2007
Status: offline

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?

(in reply to jpatridge)

Post #: 8

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

jpatridge

Posts: 13
Score: 0
Joined: 9/18/2007
Status: offline

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

(in reply to bzschenderlein)

Post #: 9