License 01A - Microsoft license ledger for Microsoft License Statements
- Fixed prompts
- Allowed “all” channel codes to be viewed
- Set default “ – All - ” as default for channel codes prompt
- Removed CollectionID from table
- Added collection name to header
- Updated font to fix overlapping issue
- Adjusted column widths to make the report more readable
- Removed extra datasource for MPLA link
- Changed the second query set to static text
- Added drill-through to MPLA URL
- Changed page size to 8.5 x 11
- Adjusted margins by a ¼ inch left and right
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Count operating system versions
- Added chart with drill-through
- Added color matching between the chart and table
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated footer
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Count operating systems and service packs
- Added chart with drill-through
- Fixed drill-through to work on the whole line and not just the first column
- Added color matching between the chart and table
- Updated the query to convert Service Packs with NULL data to '- RTM -'
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated footer
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Software 06A - Search for installed software
- Fixed prompt
- Fixed prompt text
- Very minimal changes to SQL to allow for it to work within the SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Software 01A - Summary of installed software in a specific collection
- Fixed Prompts to allow for all Publishers to be selected
- Fixed Prompt text
- Set Default “ All Publishers” as default forpublisher prompt
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
- Some SQL formatting to allow for readability
|
|
Software 02D - Computers with a specific software product
- Fixed Prompts to allow for Null items
- Fixed Prompt text
- Set Default “Null” as default for all prompts except for Collection
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated footer
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
- Some SQL formatting to allow for readability
|
|
Compliance 6 - Specific computer
- Fixed Prompt to allow for all Vendors to be selected
- Fixed Prompt to allow for all Classification to be selected
- Cleaned up Prompt query to Select PCs
- Fixed Prompt text
- Set default prompt selection for Classification (“All Classification”)
- Set default prompt selection for Vendors (“All Companies”)
- Adjusted some of the column sizes, to better mimic the ASP version of this report.
- Adjusted some column headers to be vertical to match column width.
- Allowed for the URL session of the report to go to the KB article
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
- Some SQL formatting to allow for readability
|
|
Computers with compliance evaluation failures for a specific configuration baseline
- Fixed Prompt
- Fixed Prompt text
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated Header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
- Some SQL formatting to allow for readability
|
|
Chart - Hourly advertisement completion status
- Added Chart
- Centered Table
- Fixed Prompt
- Fixed Prompt text
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Filtered out "0" results within SQL
- Updated Footer
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
- Some SQL formatting to allow for readability
|
|
Scan 2 - Last scan states by site
- Fixed Prompt to allow for Data from All Sites to be selected
- Cleaned up Prompt queries
- Fixed Prompt text
- Set default prompt selection for Sites (“All Sites”)
- Adjusted Alternating table colors to better highlight data
- Added border on both tables
- Adjusted some of the column sizes to better mimic the ASP version of this report
- Changed page size to 8.5 X 11
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
Scan 3 - Clients of a collection reporting a specific state <secondary>
- Cleaned up prompt queries
- Fixed prompt text
- Added border on both tables
- Adjusted some of the column sizes to better mimic the ASP version of this report
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
Scan 4 - Clients of a site reporting a specific state <secondary>
- Cleaned up prompt queries
- Fixed prompt text
- Added border on both tables
- Adjusted some of the column sizes to better mimic the ASP version of this report
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
Compliance details for a configuration baseline by configuration item
- Cleaned up prompt queries
- Fixed prompt text
- Added border on table
- Adjusted some of the column sizes to better mimic the ASP version of this report
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
Computers with a specific operating system and service pack
- Fixed service pack prompt to allow for all RTM versions to be selected
- Fixed service pack prompt to allow for ALL versions to be selected
- Fixed prompt text
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
History - Specific task sequence advertisements run on a specific computer
- Fixed column widths to make report more readable, particularly the Action Output column
- Changed sort order to be descending by Execution Time and Last Step, thereby making the report more usable
- Fixed conversion error within SQL
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for readability
|
|
Computers with a specific product name and version
- Fixed column widths to make the report more readable
- Fixed prompts
- Fixed prompt text
- Added defaults to each prompt
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Compliance details for a configuration baseline for a specified computer
- Fixed column widths to make the report more readable
- Fixed prompts
- Fixed prompt text
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Hardware 09A - Search for computers
- Fixed column widths to make the report more readable
- Fixed prompts
- Fixed prompt text
- Added defaults to each prompt
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
Management 1 - Updates required but not deployed
- Fixed column widths to make the report more readable
- Fixed prompts to allow for reduced query overhead
- Fixed prompt text
- Set prompt default to All Classification and All Vendors
- Added drill down on information URL
- Removed the conversion from string to integer
- Very minimal changes to SQL to allow for it to work within SQL BI tool
- Updated header
- Updated footer to move page number
- Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
- Some SQL formatting to allow for easier readability
|
|
|
|