sccmug

Remeber that I don’t use the v_R_system views to determine the last logon user and here is why. http://smsug.ca/blogs/garth_jones/archive/2007/03/22/224.aspx http://smsug.ca/blogs/garth_jones/archive/2007/03/23/225.aspx SELECT  GS.Name0, GS.UserName0, WS.LastHWScan, GS.Domain0, OS.Caption0, SYS.SystemRole0 FROM v_GS_COMPUTER_SYSTEM GS, v_GS_OPERATING_SYSTEM OS, v_GS_SYSTEM SYS, v_GS_WORKSTATION_STATUS WS WHERE GS.ResourceID = SYS.ResourceID AND WS.ResourceID = GS.ResourceID AND OS.ResourceID = GS.ResourceID AND SYS.SystemRole0<>’Server’ AND Datediff(dd,WS.LastHWScan,getdate()) > -1 AND (GS.Domain0 […]

Within SMS 2003 with SP3 there is a new view called “v_LU_HardwareReadiness”, it is clear to me that this view is a list of minimums need to install various applications. This information will be useful to create collection to install these apps. Use this query to review a list applications and their minimuns.   SELECT […]

select System_roles0, Count(System_roles0) as ‘Total’ from v_RA_System_SystemRoles group by System_roles0 order by System_roles0

select name from v_Query where targetclassname = ‘SMS_StatusMessage’ order by name  

SELECT ISC.RegisteredUser0, Count(ISC.RegisteredUser0) AS ‘Count’ FROM v_GS_Installed_Software_Categorized ISC GROUP BY ISC.RegisteredUser0  

  Recently I have been asked to do a lot of asset management reports. One piece of information that keeps being asked is “How many ____ do we have?” Fill in blank with Servers, PCs, Printers, etc.   Since we had Network discovery enable, I though that I would try another way to provide the […]

SELECT DP.PackageID, P.Name, DP.ServerNALPath, DP.SourceSite, DP.LastRefreshTime, DP.Status FROM  v_DistributionPoint DP, v_Package P WHERE DP.PackageID = P.PackageID