Month – April 2012

MMS 2012

Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened:   My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight, so I didn’t […]

Query to report OU information for Machines

For full details please see: http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx   select R.Name0, max(OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = R.ResourceID Where FCM.CollectionID = ‘SMS00001’ group by R.Name0