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
|
|
|
|
|
|