SCCM by Davis

---

• List of PC by Excel versions
• Peter Daalmans and Brian Mason are now friends
• Peter Daalmans and Peter van der Woude are now friends
• Cliff Hobbs and Peter Daalmans are now friends
• Peter Daalmans wrote a new post, Citrix XenApp 6.5 integration with ConfigMgr 2012 – part 1
• SCCM by Davis

List of PC by Excel versions Posted: 07 Oct 2012 11:17 AM PDT For full detail see forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/66b71887-acc7-40ac-8634-536784fa5adf SELECT DISTINCT R.Name0 AS 'Machine Name', left(SF.FileVersion,2) FROM dbo.v_R_System R INNER JOIN dbo.v_GS_SoftwareFile SF ON R.ResourceID = SF.ResourceID Join dbo.v_GS_SYSTEM S ON R.ResourceID = S.ResourceID WHERE S.SystemRole0 = 'Workstation' AND SF.FileName = 'excel.exe' AND SF.FilePath LIKE 'C:\Program Files%' ORDER BY R.Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }

Peter Daalmans and Brian Mason are now friends Posted: 07 Oct 2012 10:34 AM PDT Comments: 0

Peter Daalmans and Peter van der Woude are now friends Posted: 07 Oct 2012 05:22 AM PDT Comments: 0

Cliff Hobbs and Peter Daalmans are now friends Posted: 07 Oct 2012 03:52 AM PDT Comments: 0

Peter Daalmans wrote a new post, Citrix XenApp 6.5 integration with ConfigMgr 2012 – part 1 Posted: 07 Oct 2012 02:23 AM PDT A little bit more than a month ago Citrix released the Citrix XenApp connector for Configuration Manager 2012. Before I was able to have a look at the connector, I had to configure a Citrix XenApp 6.5 server in my […] Comments: 0

SCCM by Davis Posted: 06 Oct 2012 01:40 PM PDT SCCM by Davis Peter Jane wrote a new post, A little quiet, have been traveling a bit recently SCCM 2007/ 2012 Creating Queries in SCCM 2012 Joe became a registered member Nick Moseley wrote a new post, ConfigMgr Client GPO Assignment Removal Rod Trent wrote a new post, SCCM 2012 Upgrade Assessment Tool (UAT) released to beta SCCM by Davis Peter Jane wrote a new post, A little quiet, have been traveling a bit recently Posted: 05 Oct 2012 07:17 PM PDT Have been traveling a bit recently which has slowed my posting down a little. I was going to do some posting on tech but I relaxed instead and took a little visit to see some friends in Toronto. Here are a […] Comments: 0 SCCM 2007/ 2012 Posted: 10 Sep 2012 02:44 AM PDT SQL installation guide Configuration Manager required that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operation system and require GB18030 support.   If you forgot to select the correct collation, instead of completely removing and re-installing, simple run the command below. More info: http://technet.microsoft.com/en-us/library/ms179254(v=SQL.100).aspx Setup.exe /QUIET /ACTION=REBUILDDATABASE  /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=BUILTIN\Administrators   Fail to create SQL Server Certificate, ConfigMgr installation cannot be completed.   Creating Queries in SCCM 2012 Posted: 09 Sep 2012 09:55 AM PDT Peter Jane wrote a small guide on how to create queries in System Center Configuration Manager 2012. This guide is perfect for beginners in SCCM 2012 or 2007. Joe became a registered member Posted: 05 Oct 2012 04:53 PM PDT Comments: 0 Nick Moseley wrote a new post, ConfigMgr Client GPO Assignment Removal Posted: 05 Oct 2012 04:05 PM PDT On a recent upgrade project of ConfigMgr 2007 to 2012, the company I was assisting with the upgrade had previously deployed a group policy to enforce the client assignment to the 2007 site code.  However, simply […] Comments: 0 Rod Trent wrote a new post, SCCM 2012 Upgrade Assessment Tool (UAT) released to beta Posted: 05 Oct 2012 03:01 PM PDT Microsoft System Center 2012 Configuration Manager Upgrade Assessment Tool is a feature pack download that provides administrative users with information that they can use to determine if the operating system on […] Comments: 0 SCCM by Davis Posted: 05 Oct 2012 01:52 PM PDT SCCM by Davis Varun became a registered member Kevin Kaminski wrote a new post, Calgary Systems Management User Group Meeting: Configuration Manager 2012 SP1 Briefing Enhansoft and Kevin Kaminski are now friends Richard L. Tso became a registered member Riverbed Integrates VMware Virtualization Into Steelhead Appliances NantHealth Introduces Supercomputer for Cancer Genome Analysis Matt Benninge commented on the post, CM12 Automation beta released Rod Trent wrote a new post, Fix: Primary rebuild not sending software updates Rod Trent posted an update in the group IT Fit: Best Healthy Foods for Pain Relief - Prevention.com IPv6 Transition: Key Dates, Services and Issues for the Move David Prosser became a registered member Paul Sutton posted an update in the group System Center Service Manager: Using Microsoft Service Manager? Want a agnostic HTML 5 […] Paul Sutton joined the group System Center Service Manager Paul Sutton became a registered member Admin for myITforum.com wrote a new post, Help choose Enhansoft's next free SQL Server Reporting Services (SSRS) report for the month of November 2012 Eric Schloss commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Rod Trent wrote a new post, Gartner wants to charge $195 to say ConfigMgr 2012 is nice but is still lacking Rob Morris commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Rod Trent posted an update in the group Windows 8: Gearing up for the Windows 8 launch: Best Windows 8 Resources Rob Morris commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Varun became a registered member Posted: 05 Oct 2012 12:43 PM PDT Comments: 0 Kevin Kaminski wrote a new post, Calgary Systems Management User Group Meeting: Configuration Manager 2012 SP1 Briefing Posted: 05 Oct 2012 12:42 PM PDT Not that the user group is offering online attendance I thought I would open this invitation up to a larger group. Speaker: Kevin Kaminski (http://www.linkedin.com/in/kkaminsk) Configuration Manager 2012 SP1 […] Comments: 0 Enhansoft and Kevin Kaminski are now friends Posted: 05 Oct 2012 12:36 PM PDT Comments: 0 Richard L. Tso became a registered member Posted: 05 Oct 2012 11:55 AM PDT Comments: 0 Riverbed Integrates VMware Virtualization Into Steelhead Appliances Posted: 05 Oct 2012 11:30 AM PDT By integrating vSphere into its Steelhead WAN optimization appliance, Riverbed lets businesses extend virtual services to branch offices. NantHealth Introduces Supercomputer for Cancer Genome Analysis Posted: 05 Oct 2012 10:10 AM PDT NantHealth has collaborated with AT&T, HP, Intel and Verizon on a supercomputer to reduce the time required to analyze the genomic data of cancer patients. Matt Benninge commented on the post, CM12 Automation beta released Posted: 05 Oct 2012 09:22 AM PDT Nice work! Comments: 0 Rod Trent wrote a new post, Fix: Primary rebuild not sending software updates Posted: 05 Oct 2012 09:18 AM PDT On the SCCM email discussion list, Steven Mitchell had this issue: After running the client repair last night we were able to see communication with the server.  This populated the […] Comments: 0 Rod Trent posted an update in the group IT Fit: Best Healthy Foods for Pain Relief - Prevention.com Posted: 05 Oct 2012 08:44 AM PDT Best Healthy Foods for Pain Relief - Prevention.com Comments: 0 IPv6 Transition: Key Dates, Services and Issues for the Move Posted: 05 Oct 2012 09:10 AM PDT This eWEEK slide show looks at some of the issues involved in the move from IPv4 to IPv6. David Prosser became a registered member Posted: 05 Oct 2012 08:39 AM PDT Comments: 0 Paul Sutton posted an update in the group System Center Service Manager: Using Microsoft Service Manager? Want a agnostic HTML 5 […] Posted: 05 Oct 2012 08:30 AM PDT Using Microsoft Service Manager? Want a agnostic HTML 5 browser and mobile device experience then check out Cireson's Analyst Web Console. http://lnkd.in/pBuPAp Comments: 0 Paul Sutton joined the group System Center Service Manager Posted: 05 Oct 2012 08:29 AM PDT Comments: 0 Paul Sutton became a registered member Posted: 05 Oct 2012 08:21 AM PDT Comments: 0 Admin for myITforum.com wrote a new post, Help choose Enhansoft's next free SQL Server Reporting Services (SSRS) report for the month of November 2012 Posted: 05 Oct 2012 08:20 AM PDT <?xml:namespace prefix = o /?> Help choose Enhansoft's next free SQL Server Reporting Services (SSRS) report for the month of November 2012. The choices are: Software Metering Dashboard OR List of PCs by File […] Comments: 0 Eric Schloss commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Posted: 05 Oct 2012 08:17 AM PDT I can confirm that non of my Folio 13 systems have warranty information returned. I seem to remember HP telling us when it came out that it is technically a consumer device so it doesn't necessarily play by all the rules. Comments: 0 Rod Trent wrote a new post, Gartner wants to charge $195 to say ConfigMgr 2012 is nice but is still lacking Posted: 05 Oct 2012 08:08 AM PDT Gartner has released a paper to weigh in about System Center Configuration Manager 2012.  The paper, about 5 pages, talks about the product's features and improvements, but also indicates that ConfigMgr 2012 falls […] Comments: 0 Rob Morris commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Posted: 05 Oct 2012 06:55 AM PDT It is unable to locate Product Number, so I think the WMI settings may be different on the HP Folio. I have been unable to locate the Product Number Value within WMI, but will respond back if I locate it. Comments: 0 Rod Trent posted an update in the group Windows 8: Gearing up for the Windows 8 launch: Best Windows 8 Resources Posted: 05 Oct 2012 06:17 AM PDT Gearing up for the Windows 8 launch: Best Windows 8 Resources Comments: 0 Rob Morris commented on the post, Including HP Warranty Information in the SCCM Hardware Inventory Posted: 05 Oct 2012 06:02 AM PDT Has anyone been able to get this to return information for the HP Folio 13? 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 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