Month: March 2008

Ottawa Code Camp

Ottawa Code Camp 2008 (Saturday, April 5th)The OWSUG (in conjunction with the Ottawa .NET Community, the PASS Chapter, and the Ottawa Federal SharePoint Server Group) invites you to join us for the first ever Ottawa Code Camp! This full day event will give you a choice of 15 presentations in 3 tracks. Come see […]

Adding User’s OU to query

SELECT  distinct CS.Name0 as ‘NetBIOS’, CS.UserName0 as ‘UserID’, RU.Full_User_Name0 as ‘Full Name’, UOU.User_OU_Name0 as ‘Users OU’, RA.IP_Subnets0 as ‘Subnet’ from dbo.v_GS_COMPUTER_SYSTEM CS  FULL join dbo.v_RA_System_IPSubnets RA on RA.ResourceID = CS.ResourceID FULL join dbo.v_R_User RU on RU.Unique_User_Name0 = CS.UserName0 FULL join dbo.v_RA_User_UserOUName UOU on UOU.ResourceID = RU.ResourceID Order by  CS.Name0,   CS.Username0,  RU.Full_User_Name0, RA.IP_Subnets0

Adding “SMS Scanned Date” to a software inventory report

SELECT DISTINCT CS.Name0, CS.UserName0, ARP.DisplayName0, WS.LastHWScanFROM dbo.v_GS_ADD_REMOVE_PROGRAMS ARP, dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_WORKSTATION_STATUS WSWHERE ARP.ResourceID = CS.ResourceID AND CS.ResourceID = WS.ResourceID AND (ARP.DisplayName0 Like ‘%microsoft%office%pro%’   OR ARP.DisplayName0 Like ‘%microsoft%office%stan%’)  And (ARP.DisplayName0 Not Like ‘%visio%’   And ARP.DisplayName0 Not Like ‘%Proof%’   And ARP.DisplayName0 Not Like ‘%Project%’)

Get certified on System Center

I am reading blog posts in my hotel this morning before going for breakfast. I noticed that Trika has posted a note about ConfigMgr / System Center and Exam.   What about a certification for Data Protection Manager or other System Center solutions? What I hear: “We are working on the future plan for System […]

ConfigMgr Presentation extra resources

Community Resource Windows Management User Group FAQ Shop (UK Based) myITforum SMS User Group Canada Other Resources SCCM 2007 Capacity Planner ULTIMATE SMS LOGON SCRIPT V.4.11 SMSMAP SMS/ConfigMgr documentation script SYDI-Server, SYDI- SQL , SYDI-Exchange, SYDI-Linux (Documentation scripts) SCCM Console Right Click Tools […]