myITforum.com Community Forum 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/clients pending reboot

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

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Collection of machines/clients pending reboot Page: [1]
Login
Message << Older Topic   Newer Topic >>
Collection of machines/clients pending reboot - 4/18/2008 3:45:57 PM   
akhoygani975

 

Posts: 2
Score: 0
Joined: 4/18/2008
Status: offline 		Hello all,

In SMS2003 I had a collection listing all servers/clients that were pending reboot (see query statement):

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 inner join SMS_G_System_PatchStatus on SMS_G_System_PatchStatus.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PatchStatus.LastStateName = "Reboot Pending"    

I am trying to use the same Select query in SCCM 2007 and does not return anything. Does anyone know why? and if this is not supported in SCCM 2007 is there any other way to create the above collection?

Thanks.
Post #: 1
RE: Collection of machines/clients pending reboot - 4/18/2008 4:04:25 PM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		The tables/views/classes in SCCM are very very similar, but not identical.  I don't have SCCM up right now, but if you create a dummy collection/query and look at the query you'll see the new names.


_____________________________

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

(in reply to akhoygani975)
Post #: 2
RE: Collection of machines/clients pending reboot - 4/18/2008 4:22:49 PM   
akhoygani975

 

Posts: 2
Score: 0
Joined: 4/18/2008
Status: offline 		John,

I have done that and tried all possible names but no luck yet, I will continue the search.

Thank you for the reply.

Abe

(in reply to jnelson993)
Post #: 3
RE: Collection of machines/clients pending reboot - 4/21/2008 7:08:22 PM   
phaustein


Posts: 859
Score: 32
Joined: 3/21/2005
From: Washington, DC
Status: offline 		Try using the patch status extended table instead. I do have data in the table, but nothing in that that status but it does work with other statuses.  Below is a modified version of what you had posted.  Let me know how it goes.

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 inner join SMS_G_System_PatchStatusex on SMS_G_System_PatchStatusex.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PatchStatusex.LastStateName = "Reboot Pending"

_____________________________

Hope this helps.
Paul

(in reply to akhoygani975)
Post #: 4
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Collection of machines/clients pending reboot Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.234