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 […]
Month: June 2007
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 […]
Some recently published updates on Softgrid and MDOP which I thought you may all enjoy !!! Have a great weekend DART: http://www.microsoft.com/downloads/details.aspx?FamilyID=5d600369-0554-4595-8ab4-c34b2860e087&displaylang=en SoftGrid 4.1 SP1 is posted on the external download.microsoft.com website: SoftGrid Sequencer (4.1.1.303) http://download.microsoft.com/download/0/6/c/06cf3aac-347e-4e42-9355-fcfcec3c7f43/SoftGrid_sequencer_setup_4.1.1.303.exe SoftGrid Server (4.1.1.302) http://download.microsoft.com/download/a/f/c/afc8cf1f-d271-426e-923a-b04a34674c3c/SoftGrid_server_setup_4.1.1.302.exe SoftGrid for Windows Terminal Services (4.1.1.302) http://download.microsoft.com/download/f/0/1/f01b4fcd-8778-4e49-b56c-7ae6ab72f6ff/SoftGrid_ts_setup_4.1.1.302.exe SoftGrid for Windows […]
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 […]
Recently, while looking of some information on the net, I found myself reading one of the SMS news groups Microsoft.public.SMS.inventory. Looking for some information In this news group I came across this little Gem! MS Technical Article 828368 This Gem is entitled “List of technical resources for Systems Management Server 2003” http://support.microsoft.com/default.aspx?scid=kb;en-us;828368 This article […]
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
Deploying System Center Configuration Manager 2007 Q&A with the SCCM 2007 Deployment Feature team. Add to Calendar June 29, 2007 10:00 A.M. Pacific Time Additional Time Zones EnterChatRoom Operating System Deployment with System Center Configuration Manager 2007 Q&A with the SCCM 2007 OSD Feature Team Add to Calendar July 10, 2007 10:00 A.M. Pacific […]