Open the Spider Admin Tool
Click on Spider Core Reporting
For this scenario we have clicked on 'Inventory' and selected 'Inventory: Programs per System'
Below shows the actual SQL query in the 'Data' tab please note, you cannot edit this Standard Report
Allocated roles on the 'Roles' tab
Find the View which is being queried in SQL Server Management Studio
Right-click Views and filter for swr_AssetSoftwareScan
Then open it in a New Query Editor Window with ‘Script View as’ and ‘Create To’
Change the name of this query, for example add CUST, then click on Execute (run query)
The changed query has been saved and can be found as a new View
Make the required changes to the Query with ‘Script View as’ and ‘Alter To’ and save it (Ctrl + S or File - Save)
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…
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’
Click Next and then OK to save this
The new report will now be visible in the Spider Reports Web interface
