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

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

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” http://support.microsoft.com/default.aspx?scid=kb;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 […]