cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Open the Spider Admin Tool

Click on Spider Core Reporting

peter_link_0-1656601015821.png

For this scenario we have clicked on 'Inventory' and selected 'Inventory: Programs per System'

peter_link_1-1656601015947.png

Below shows the actual SQL query in the 'Data' tab please note, you cannot edit this Standard Report

peter_link_2-1656601015991.png

Allocated roles on the 'Roles' tab

peter_link_3-1656601016011.png

 

Find the View which is being queried in SQL Server Management Studio

Right-click Views and filter for swr_AssetSoftwareScan

peter_link_4-1656601016033.png

Then open it in a New Query Editor Window with ‘Script View as’ and ‘Create To’

peter_link_5-1656601016070.png

 

Change the name of this query, for example add CUST, then click on Execute (run query)

peter_link_6-1656601016097.png

The changed query has been saved and can be found as a new View

peter_link_7-1656601016116.png

 

Make the required changes to the Query with ‘Script View as’ and ‘Alter To’ and save it (Ctrl + S or File - Save)

peter_link_8-1656601016153.png

Now you are ready to create a new report in the Spider Admin Tool

Right-click in the blank area of the Report Windows and click on Add…

peter_link_9-1656601016253.png

Complete the Name and Description Fields on the ‘General’ tab, add the Query Statement on the ‘Data’ tab and assign the Roles on the ‘Roles tab. You can test the query by clicking on the blue arrow.

On the ‘General tab’ put a tick in both the tick boxes for ‘Auto Search’ and ‘Read uncommitted’

peter_link_10-1656601016284.png

Click Next and then OK to save this

The new report will now be visible in the Spider Reports Web interface

Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Sep 22, 2022 01:09 AM
Updated by: