Browsing: SQL Queries

Are you looking for getting a report for a given KB numbers or MSID(like MS10-087),you can add few more lines…

I was searching for something to find the software update complaince to see if machines requires something to patch .as…

In my daily work routine,i used to work with some of the web report to present it to management as…

The below scripts works for only Win 2000 and XP not for other operating systems .Here are the simple steps…

This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory…

This Report will help you in identifying the collection that are member of any other parent collection. SELECT COL.CollectionID, COL.Name,…

Gives list of computers where Programs installed recently. SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM…

  Select  Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from dbo.v_GS_SYSTEM Sys Where   Sys.SMSID0 = @GUID Prompt for GUID: select SMS_Unique_Identifier0 from v_R_System