AI Report Errors
- Windows 7 machines show as XP installed.
We don't have 15 SQL Server Enterprise machines we have 6 as the drill down report showes.
License 01A - Microsoft license ledger for Microsoft License Statements
SQL Server - Standard SQL Server - Standard 2000 2000 2 3 LP200050 SQL Server Enterprise - 1 Processor SQL Server Enterprise 2005 - 1 Processor 2005 15 0 LP200050 SQL Server Standard - 1 Processor SQL Server Standard 2005 - 1 Processor 2005 56 0 LP200050
License 01B - Microsoft license ledger item by sales channel
SQL Server Enterprise 2005 - 1 Processor 0 15 LP200050
License 01C - Computers with a specific Microsoft license ledger item and sales channel
11/19/2009 2:26:13 PM(Number of Records: 6) LPS18029 Corporate Site lpcorp\lpubackup None No Asset Tag VMware, Inc. VMware Virtual Platform 77574-271-0000025-05067 0 LPS18039 Corporate Site Dell Inc. PowerEdge 2950 77591-271-0000025-05884 0 LPS18122 Corporate Site lpcorp\lpubackup Dell Computer Corporation PowerEdge 2800 77574-271-0000025-05639 0 LPS18133T Corporate Site lpcorp\lpubackup Dell Inc. PowerEdge 1950 77591-271-0000025-05270 0 LPS18599 Corporate Site lpcorp\lpubackup Dell Inc. PowerEdge 2950 77591-271-0000025-05007 0 YNS18625 Corporate Site lpcorp\lpubackup Dell Inc. PowerEdge 2900 77591-271-0000025-05482 0
Are we missing some published fixes to AI reports? Currentl running ConfigMgr2007R2SP2 on Windows 2008SP2 w/ SQL2005SP3
Gary
답변
- For the SQL part of the issue with the License 01A/01B/01C reports, the problem is with the queries in the License 01A and License 01B reports. The License 01C report is accurate.
The quesries for the first 2 reports count all components of SQL as separate licenses (i.e., database engine, report services, analysis services), so you get multiple licenses per system. To get accurate SQL license counts for the 01A and 01B, you need to change the following in the queries of the reports:
Locate "count(v_GS_INSTALLED_SOFTWARE_MS.ResourceID)" and change it to "count(DISTINCT v_GS_INSTALLED_SOFTWARE_MS.ResourceID)". The keyword DISTINCT in the COUNT() function will force it to ignore duplicates.
You can also clone the reports and then edit them. If you clone the reports, don’t forget to change the link in the modified License 01A to point to the modified License 01B report.
Thanks, Chris
Chris Amaris- 답변으로 표시됨mx5gary 2009년 12월 29일 화요일 오후 4:23
모든 응답
- For the SQL part of the issue with the License 01A/01B/01C reports, the problem is with the queries in the License 01A and License 01B reports. The License 01C report is accurate.
The quesries for the first 2 reports count all components of SQL as separate licenses (i.e., database engine, report services, analysis services), so you get multiple licenses per system. To get accurate SQL license counts for the 01A and 01B, you need to change the following in the queries of the reports:
Locate "count(v_GS_INSTALLED_SOFTWARE_MS.ResourceID)" and change it to "count(DISTINCT v_GS_INSTALLED_SOFTWARE_MS.ResourceID)". The keyword DISTINCT in the COUNT() function will force it to ignore duplicates.
You can also clone the reports and then edit them. If you clone the reports, don’t forget to change the link in the modified License 01A to point to the modified License 01B report.
Thanks, Chris
Chris Amaris- 답변으로 표시됨mx5gary 2009년 12월 29일 화요일 오후 4:23
