| 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
| 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
| 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 | | 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 | | 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   |
No hay comentarios:
Publicar un comentario