SCCM by Davis: “Chris Thomas became a registered member” plus 12 more

---

• Chris Thomas became a registered member
• Garth Jones wrote a new post, How to Add Blank Columns to a report.
• Sprint iPhone Owners in San Francisco Suffering Lousy Service
• How to Add Blank Columns to a report.
• #ConfigMgr / #SCCM 2012 :: Import Pre-Configured Applications and Become an Expert in New Application Model
• SCCM Links
• SCCM 2012: How to remove an Update installed via offline service
• SCCM 2012: Post-TS action
• SCCM 2012: OSD–move computer to a different OU
• SCCM 2012: Automatic installation script(s)
• SCCM 2012: Fast Client Notification
• Nick Moseley wrote a new post, Custom query of ACT data for apps with issues
• SCCM by Davis: “JohnA became a registered member” plus 19 more

Chris Thomas became a registered member Posted: 08 Dec 2012 08:01 PM PST Comments: 0

Garth Jones wrote a new post, How to Add Blank Columns to a report. Posted: 08 Dec 2012 08:04 AM PST For full details please see: http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx SELECT DISTINCT CS.Name0 as 'PC', '' as 'Blank column1', BIOS.SerialNumber0 as 'SN […] Comments: 0

Sprint iPhone Owners in San Francisco Suffering Lousy Service Posted: 08 Dec 2012 08:15 AM PST Sprint iPhone owners in the San Francisco area are experiencing "near unusable" service. Sprint says, with Apple, it's working on it.

How to Add Blank Columns to a report. Posted: 08 Dec 2012 08:04 AM PST For full details please see: http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx SELECT DISTINCT CS.Name0 as 'PC', '' as 'Blank column1', BIOS.SerialNumber0 as 'SN #', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', '' as 'Blank column2', OS.Caption0 as 'OS', OS.CSDVersion0 as 'Service Pack', SCUM.TopConsoleUser0 as 'Top User', R.User_Name0 AS 'Last Logged (Heartbeat)', CS.UserName0 AS 'Last Logged (HW Inv.)', BIOS.ReleaseDate0 as 'Bios Date', NAC.IPAddress0 as 'IP', NAC.DefaultIPGateway0 as 'Gateway', '' as 'Blank column3', Case SE.ChassisTypes0 when '1' then 'Other' when '2' then 'Unknown' when '3' then 'Desktop' when '4' then 'Low Profile Desktop' when '5' then 'Pizza Box' when '6' then 'Mini Tower' when '7' then 'Tower' when '8' then 'Portable' when '9' then 'Laptop' when '10' then 'Notebook' when '11' then 'Hand Held' when '12' then 'Docking Station' when '13' then 'All in One' when '14' then 'Sub Notebook' when '15' then 'Space-Saving' when '16' then 'Lunch Box' when '17' then 'Main System Chassis' when '18' then 'Expansion Chassis' when '19' then 'SubChassis' when '20' then 'Bus Expansion Chassis' when '21' then 'Peripheral Chassis' when '22' then 'Storage Chassis' when '23' then 'Rack Mount Chassis' when '24' then 'Sealed-Case PC' else 'Undefinded' end as 'PC Type' FROM dbo.v_R_System R INNER JOIN dbo.v_GS_PC_BIOS BIOS ON R.ResourceID = BIOS.ResourceID INNER JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON R.ResourceID = CS.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC ON R.ResourceID = NAC.ResourceID INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON R.ResourceID = OS.ResourceID LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM ON R.ResourceID = SCUM.ResourceID INNER JOIN dbo.v_GS_SYSTEM S on R.ResourceID = S.ResourceID INNER JOIN dbo.v_GS_SYSTEM_ENCLOSURE SE on R.ResourceID = SE.ResourceID WHERE NAC.IPEnabled0 = 1 AND NAC.DefaultIPGateway0 Is NOT NULL AND S.SystemRole0 = 'Workstation' ORDER BY BIOS.ReleaseDate0

#ConfigMgr / #SCCM 2012 :: Import Pre-Configured Applications and Become an Expert in New Application Model Posted: 12 Oct 2012 09:47 AM PDT Import Pre-Configured Applications to ConfigMgr 2012 console and Become an Expert in New Application

SCCM Links Posted: 12 Oct 2012 12:07 AM PDT Guides Sysprep Windows 7 Machine Start to Finish Which sccm version is installed ? Installing icp on sccm 2007 Hotfixes You cannot import a driver into an OSD image if the driver is signed for only the Windows 7 operating system in System Center Configuration Manager 2007 SP2 Link

SCCM 2012: How to remove an Update installed via offline service Posted: 11 Oct 2012 09:27 AM PDT When you use Offline image servicing in SCCM you can add updates, but there is no clear way to remove them (for example if update is obsolete). You can do it manually using DISM. Step-by-step is here

SCCM 2012: Post-TS action Posted: 11 Oct 2012 09:09 AM PDT SP1 for SCCM 2012 introduces a new TS Variable SMSTSPostAction. This variable can be populated with a command to perform after the TS finish.

SCCM 2012: OSD–move computer to a different OU Posted: 11 Oct 2012 09:04 AM PDT Peter provides an example of SCCM/Orchestrator integration (MDT 2012  Upd 1 is required at this moment). Using the power of Orchestrator to move a computer to a different OU via ConfigMgr 2012

SCCM 2012: Automatic installation script(s) Posted: 11 Oct 2012 08:53 AM PDT Raphael, one of MVPs is developing a PowerShell script suite for SCCM installation automation. Project is here:  http://cm12automation.codeplex.com/. How-to is here: http://wmug.co.uk/wmug/b/dotraphael/archive/2012/09/28/project-cm12-automation-beta-is-coming.aspx

SCCM 2012: Fast Client Notification Posted: 11 Oct 2012 08:41 AM PDT SP1 for SCCM 2012 introduces a new feature – Fast Client Notification. You will be able to avoid minutes (or hours) waiting while client actually pools  a policy. Whole article is  here: http://blogs.technet.com/b/configmgrteam/archive/2012/09/27/fast-channel-for-system-management.aspx

Nick Moseley wrote a new post, Custom query of ACT data for apps with issues Posted: 08 Dec 2012 06:12 AM PST The application compatibility toolkit (ACT) is a great tool for analyzing compatibility of apps when doing a migration of Windows.  However, the available "reports" are limited in what they display out-of-box.  […] Comments: 0

SCCM by Davis: “JohnA became a registered member” plus 19 more Posted: 08 Dec 2012 02:04 AM PST SCCM by Davis: "JohnA became a registered member" plus 19 more JohnA became a registered member Vu became a registered member Rod Trent wrote a new post, myITforum live from Dell World next week Dustin Hedges changed their profile picture Rod Trent wrote a new post, Friday fun: Play the Sysman Hero game Rod Trent uploaded the file: MMS 2013 Cost Justification Document to Microsoft Management Summit Rod Trent deleted the file: MMS 2013 Cost Justification Document from Microsoft Management Summit David Bradford became a registered member Amnon Feiner became a registered member Rod Trent deleted the file: MMS 2013 Cost Justification Document from Microsoft Management Summit Rod Trent posted an update in the group Microsoft Management Summit: Guide to alternate MMS 2013 hotels Rod Trent wrote a new post, Guide to alternate MMS 2013 hotels JohnL joined the group SCCM Right-click tools Rod Trent posted an update in the group Microsoft Management Summit: First MMS 2013 cost justification document now available Rod Trent wrote a new post, First MMS 2013 cost justification document now available Rod Trent uploaded the file: Alternate hotel pricing for MMS 2013 to Microsoft Management Summit Rod Trent uploaded the file: MMS 2013 Cost Justification Document to Microsoft Management Summit Rod Trent posted an update in the group Microsoft Management Summit: Cost-effective transportation around Las Vegas for MMS 2013 Rod Trent wrote a new post, Cost-effective transportation around Las Vegas for MMS 2013 JohnL became a registered member JohnA became a registered member Posted: 07 Dec 2012 06:10 PM PST Comments: 0 Vu became a registered member Posted: 07 Dec 2012 03:57 PM PST Comments: 0 Rod Trent wrote a new post, myITforum live from Dell World next week Posted: 07 Dec 2012 02:27 PM PST Just a quick note to let everyone know that we'll be at Dell World next week, providing information through blogging and social media here on myITforum.  Dell World looks to be a significant conference and it will […] Comments: 0 Dustin Hedges changed their profile picture Posted: 07 Dec 2012 01:09 PM PST Comments: 0 Rod Trent wrote a new post, Friday fun: Play the Sysman Hero game Posted: 07 Dec 2012 12:46 PM PST SolarWinds has posted up a pretty cool web game called Sysman Hero, and it could get you straight to closing time a lot quicker than sitting around watching the clock. About the game: Out of the deepest, […] Comments: 0 Rod Trent uploaded the file: MMS 2013 Cost Justification Document to Microsoft Management Summit Posted: 07 Dec 2012 12:20 PM PST From Chris Stauffer, use this cost justification document to help ensure your attendance for MMS 2013. Comments: 0 Rod Trent deleted the file: MMS 2013 Cost Justification Document from Microsoft Management Summit Posted: 07 Dec 2012 12:19 PM PST Comments: 0 David Bradford became a registered member Posted: 07 Dec 2012 11:49 AM PST Comments: 0 Amnon Feiner became a registered member Posted: 07 Dec 2012 11:45 AM PST Comments: 0 Rod Trent deleted the file: MMS 2013 Cost Justification Document from Microsoft Management Summit Posted: 07 Dec 2012 11:20 AM PST Comments: 0 Rod Trent posted an update in the group Microsoft Management Summit: Guide to alternate MMS 2013 hotels Posted: 07 Dec 2012 09:18 AM PST Guide to alternate MMS 2013 hotels Comments: 0 Rod Trent wrote a new post, Guide to alternate MMS 2013 hotels Posted: 07 Dec 2012 09:15 AM PST Chris Stauffer did the research and has provided a nice guide to hotels that are close to the Mandalay Bay.  In the guide he provides some alternate hotel options that include price and distance (walk […] Comments: 0 JohnL joined the group SCCM Right-click tools Posted: 07 Dec 2012 08:54 AM PST Comments: 0 Rod Trent posted an update in the group Microsoft Management Summit: First MMS 2013 cost justification document now available Posted: 07 Dec 2012 08:47 AM PST First MMS 2013 cost justification document now available Comments: 0 Rod Trent wrote a new post, First MMS 2013 cost justification document now available Posted: 07 Dec 2012 08:44 AM PST Thanks to Chris Stauffer for being so quick to put this together.  Use this cost justification document to help ensure your attendance for MMS 2013.  Make any modifications that meet your manager's requirements […] Comments: 0 Rod Trent uploaded the file: Alternate hotel pricing for MMS 2013 to Microsoft Management Summit Posted: 07 Dec 2012 08:38 AM PST Chris Stauffer has put together this document showing alternate hotel pricing for MMS 2013. It includes total hotel cost for the week and walk time between the hotel and the MMS 2013 convention center. Comments: 0 Rod Trent uploaded the file: MMS 2013 Cost Justification Document to Microsoft Management Summit Posted: 07 Dec 2012 08:36 AM PST From Chris Stauffer, use this cost justification document to help ensure your attendance for MMS 2013. Comments: 0 Rod Trent posted an update in the group Microsoft Management Summit: Cost-effective transportation around Las Vegas for MMS 2013 Posted: 07 Dec 2012 08:31 AM PST Cost-effective transportation around Las Vegas for MMS 2013 Comments: 0 Rod Trent wrote a new post, Cost-effective transportation around Las Vegas for MMS 2013 Posted: 07 Dec 2012 08:28 AM PST If you're following our suggestion to save money by staying at an alternate hotel (Looking to attend MMS 2013 on the cheap? Alternate hotels available), you may be concerned about the distance between your hotel […] Comments: 0 JohnL became a registered member Posted: 07 Dec 2012 08:18 AM PST Comments: 0 You are subscribed to email updates from SCCM by Davis To stop receiving these emails, you may unsubscribe now. Email delivery powered by Google Google Inc., 20 West Kinzie, Chicago IL USA 60610 System Center Configuration Manager - Davis Blog

You are subscribed to email updates from SCCM by Davis To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610