SELECT COL.CollectionID, COL.Name, COL.Comment, CTSC.parentCollectionIDFROM dbo.v_Collection COL, dbo.v_CollectToSubCollect CTSCWHERE CTSC.subCollectionID = COL.CollectionID
Month: October 2008
When troubleshooting BITS, use GPResult to find out which policy is setting the BITS settings. From a Administrator CMD, execute the following: gpresult /SCOPE COMPUTER /H GPR.html Then open the GPR.html
At last week’s user group meeting, I hand out a quick survey of the event and what topic we should do next. The results are fairly interesting: Take more that 10 minutes to write a survey and have someone else proof read it. (Foot) 🙂 The session content applied to everyone The session was not […]
The Creating Custom Reports by Using Configuration Manager 2007 SQL Views documentation is out. This documentation provides the information to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be […]
Free Evening Event @ Microsoft Ottawa Thursday, November 13th 5:15 – 8:00 PM Feature Presentation: Upgrading and Migrating to SQL Server 2008 Best Practices and Lessons from the Field, Damir Bersinic Damir will be in town for the Ottawa stop of the Align IT tour on November 13th. He will be taking this opportunity to […]
SELECT CS.UserName0Into #tmpFROM dbo.v_GS_Computer_system CSgroup by CS.UserName0Having Count(CS.UserName0) > 1 SELECT CS.Name0, CS.Manufacturer0, CS.Model0, CS.UserName0FROM dbo.v_GS_Computer_system CS, #tmpWhere #tmp.UserName0 = CS.UserName0 or CS.UserName0 != NullOrder by CS.UserName0, CS.Name0, CS.Manufacturer0, CS.Model0 Drop table #tmp
It not even November yet and we are getting ~20 cm (~8 inch)of snow in the next 24 hours! The funny part is, last night they were calling for 35+ cm!
TODAY is the second and last week of EXAM Review day! Please remember to sign up for tonight session and good luck on your exam!
Have you see the new game MS released to Vista Ultimate? Don’t play Tinker unless you have a few hours to kill!!
Listed in order: Show Desktop Internet Explorer Outlook Live Writer Microsoft Query Microsoft SQL Server Management Studio SnagIt 8 ConfigMgr help file SCVMM Console VMCRPlus Hyper-V Manager ConfigMgr SDK help file ConfigMgr Console OpsMgr Console