Create a custom SAM report

You can combine any SolarWinds Platform Web Console widget or chart into a report. In this example, a custom report for IIS servers is created by modifying a predefined report, then adding a few more widgets for a complete picture of your IIS servers. To create this custom report, you will first need to create a custom property to identify nodes running IIS.

This report provides information about:

• IIS servers with disks approaching 100%
• Capacity for all disk volumes from the last seven days
• The percentage of disk space used for all disk volumes from the last seven days
• IIS instances with problems
• Availability of IIS Nodes
• Nodes with problems

Create a custom property to identify nodes running IIS

1. In the SolarWinds Platform Web Console, click Settings > All Settings > Manage Custom Properties.
2. Click Add Custom Properties.
3. On the Select Object panel, select Nodes, and click Next.
4. On the Choose Properties panel, in the Property Name field, enter Type.
5. In the Format field, select Text.

6. Select Restrict values, and in the Value 1 field, enter IIS.

   You can enter more values to identify other server types. This example uses just the IIS server type.

   

7. For Usage, select everything except Asset Inventory, and click Next.

   

8. On the Assign Values panel, click Select Nodes.
9. Select the nodes to which you want to assign the property, and click Add.

10. In the list of Selected Nodes, click Select All, then click Select Nodes.

    

11. Select IIS from the drop-down menu, and click Submit.

    

Create the IIS application server issue rollup report

1. Click Reports > All Reports > Manage Reports, and locate Disks Approaching 100% Capacity - This Month.

   

2. Select the report, and click Duplicate & Edit.
3. Enter the report name, for example, IIS Application Server Issue Rollup.
4. For the widget in the first default row, click Edit Chart, rename the chart to IIS Servers with Disks Approaching 100% Capacity, and click Submit.
5. In the From field, select Last 7 Days.

6. Click Edit.

   

7. Click the plus sign (+), and click Add Simple Condition.

   

8. Click Select Field, and then locate and select Node > Nodes Custom Properties > Type.

9. Click Add Column.

   

10. Select IIS from the drop-down menu, ensuring the query reads Type is equal to IIS.

    

11. Add another simple condition, and locate and select Percent Used under Volume Current Statistics.
12. Click Add Column.



13. Select the is greater than operator and enter 70.

    The query should read: Percent used is greater than 70.

14. Click Add to Layout.

    

15. For the widget in the second default row, in the From field, select Last 7 Days.

    

16. Click Add Content.
17. In the Group By field, select Classic category.
18. Select SAM Application Summary Report, and click Applications with Problems.

19. Click Select and Continue.

    

20. On the Layout Builder panel, click Edit Resource, and in the Title field, enter IIS Instance with Problems.
21. Add the following SWQL filter: Application.Name='Microsoft IIS'
22. Click Submit.

    

23. Click Add Content > Classic Category > Summary Reports > Availability of Each Node.

24. Click Select and Continue.

    

25. Click Edit Resource, and in the Select a Time Period field, select Last 7 Days.
26. In the Filter Nodes (SQL) field, enter: type='IIS'.

27. Click Submit.

    

When complete, your report should look similar to the following: