Collection of machines/clients pending reboot (Full Version)

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager



Message

akhoygani975 -> Collection of machines/clients pending reboot (4/18/2008 3:45:57 PM)

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.



jnelson993 -> RE: Collection of machines/clients pending reboot (4/18/2008 4:04:25 PM)

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.



akhoygani975 -> RE: Collection of machines/clients pending reboot (4/18/2008 4:22:49 PM)

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



phaustein -> RE: Collection of machines/clients pending reboot (4/21/2008 7:08:22 PM)

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"



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.203125