Month: June 2007

Last logon User query

Remeber that I don’t use the v_R_system views to determine the last logon user and here is why. 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 […]

Hardware Readiness

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 […]

MDOP Updates Available (SP1)

Some recently published updates on Softgrid and MDOP which I thought you may all enjoy !!!  Have a great weekend   DART:   SoftGrid 4.1 SP1 is posted on the external website: SoftGrid Sequencer (   SoftGrid Server (   SoftGrid for Windows Terminal Services (   SoftGrid for Windows […]

All IP Device Reports

  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 […]

MS Technical article 828368

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”;en-us;828368 This article […]

TechNet Chats

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 […]