May 2011 - Posts

• Server by Collection

  select Distinct CS .Name0, CS .Domain0, OS .Caption0 From dbo .v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where S .SystemRole0 = 'Server' and FCM.CollectionID = 'SMS00001' Posted Friday, May 06, 2011 6:10 AM from SMSUG.ca | 0 Comments Filed under: SQL, SMS, System Center, ConfigMGr, SCCM

• Canadian Microsoft Management Summit 2011

  Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud)   When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events/event_details.aspx?event_id=1032484234 Posted Monday, May 02, 2011 6:58 AM from SMSUG.ca | 0 Comments Filed under: SMS, System Center, Canada, ConfigMGr, Windows 2008, Training, SCMDM, SCVMM, SCSM, SCE, Microsoft Canada, Windows 7, SCCM, Microsoft, vNext

• Query Logic

  SELECT SYS.Netbios_Name0, SF.FileName, SF.FileSize/1024/1024 AS 'Size, KB', SF.FilePath FROM dbo.v_GS_SoftwareFile AS SF INNER JOIN dbo.v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID where (SF.FileName LIKE '%.pdf' AND SF.FilePath LIKE '%My Documents%') OR (SF.FileName LIKE '%.pdf' AND SF.FilePath LIKE '%Desktop%') OR (SF.FileName LIKE '%.pdf' AND SF.FilePath LIKE '%C:\%') and SF.FileSize>1024 ORDER BY SYS.Netbios_Name0 Posted Monday, May 02, 2011 6:01 AM from SMSUG.ca | 0 Comments Filed under: SQL, SMS, System Center, ConfigMGr