SCOM plugin

An on-prem data source connects a service running in your internal network to SquaredUp. They require an agent installed on a machine that has access to your internal network.

• Consider which objects you want to index and set the permissions for the service account accordingly. As the SCOM data source supports SCOM RBAC you can use scoping in the user role for the account in SCOM to control which objects will be indexed.
• You need to manually add the service account to the opsmgreader role of the Data Warehouse in the SCOM console see Manually creating the Data Warehouse permissions

Timeframe format differs in SquaredUp Cloud and SquaredUp DS for SCOM (Cloud using zero hour / minute for "hours and minutes"), meaning you will retrieve more values in Cloud if there is a noisy metric - which is more likely the further from the top of the hour you are.

For example, if you want to request the Last 24 hours in Cloud, the following format is used:

"timeframe": { "start": "2024-10-07T22:00:00.000Z", "unixStart": 1712527200, "end": "2024-10-08T22:00:00.000Z", "unixEnd": 1712613600, "enum": "last24hours", "interval": "PT15M" }

Whereas DS for SCOM uses the following format:

start: 10/07/2024 22:19:34 end: 10/08/2024 22:19:34

Likewise, the following format is used in Cloud for a seven-day request:

"timeframe": { "start": "2024-10-01T18:00:00.000Z", "unixStart": 1711994400, "end": "2024-10-08T18:00:00.000Z", "unixEnd": 1712599200, "enum": "last7days", "interval": "PT6H" }

Whereas DS for SCOM uses the following format:

start: 10/01/2024 18:09:56 end: 10/08/2024 18:09:56

When Configuring the data source, you can select the Advanced Settings check box to display the Custom Classes section, which allows you to retrieve additional classes from SCOM.

If you want to retrieve custom classes, do the following:

1. Click the Add new custom classes button to display the entry fields.
2. Enter a name for the additional class in the Class name field. For example, Windows Computer.
3. Enter / paste the JSON for the class you want to import in the Custom class JSON field. For example:
   
   Copy

   [
      {
         "name":"Import class 'Microsoft.Windows.Computer'",
         "classId":"ea99500d-8d52-fc52-b5a5-10dcd1e9d2bd",
         "types":[
            {
               "className":"Microsoft.Windows.Server.DC.Computer",
               "type":"addomaincontroller"
            },
            {
               "className":"Microsoft.Windows.Computer",
               "type":"host"
            }
         ],
         "properties":[
            
         ],
         "children":[
            {
               "name":"Import related class 'Microsoft.Windows.LogicalDevice'",
               "classId":"3361982a-7dfd-288d-f48c-e04e85149750",
               "types":[
                  {
                     "className":"Microsoft.Windows.LogicalDisk",
                     "type":"volume"
                  },
                  {
                     "className":"Microsoft.Windows.NetworkAdapter",
                     "type":"interface"
                  }
               ],
               "properties":[
                  
               ]
            }
         ]
      }
   ]

   The properties parameter

   The optional properties parameter is a special property that provides a mechanism to add or modify properties from the target class. Here is the basic structure of the properties parameter:

   Copy

   "properties":[
      {
         "name":"Parameters",
         "as":"monitorUrl",
         "XPath":"/Parameters/Parameter[@name='URL']",
         "transform":"url"
      }
   ]

   Example

   To add a new property, simply omit the XPath, jsonPath, and transform options. Here is a functional example that adds the NetbiosComputerName field to the Windows Computer class:

   Copy

   [
      {
         "name":"Import class 'Microsoft.Windows.Computer'",
         "classId":"ea99500d-8d52-fc52-b5a5-10dcd1e9d2bd",
         "types":[
            {
               "className":"Microsoft.Windows.Server.DC.Computer",
               "type":"addomaincontroller"
            },
            {
               "className":"Microsoft.Windows.Computer",
               "type":"host"
            }
         ],
         "properties":[
            {
               "name":"NetbiosComputerName",
               "as":"netbiosComputerName"
            }
         ],
         "children":[
            {
               "name":"Import related class 'Microsoft.Windows.LogicalDevice'",
               "classId":"3361982a-7dfd-288d-f48c-e04e85149750",
               "types":[
                  {
                     "className":"Microsoft.Windows.LogicalDisk",
                     "type":"volume"
                  },
                  {
                     "className":"Microsoft.Windows.NetworkAdapter",
                     "type":"interface"
                  }
               ],
               "properties":[
                  
               ]
            }
         ]
      }
   ]

4. Optionally, click the Add another custom class button to add an additional class and enable another line of entry fields.
   Example
   Here is a functional example of Custom class JSON you can enter to imports the Web Application Test Web Test Base class from SCOM:
   Copy

   [
      {
         "name":"Import class 'Microsoft.SystemCenter.WebApplicationTest.WebTestBase'",
         "classId":"8e5cb3e8-3a88-4301-a703-553772fe72dd",
         "types":[
            {
               "className":"Microsoft.SystemCenter.WebApplicationTest.WebTestBase",
               "type":"monitor"
            }
         ],
         "properties":[
            {
               "name":"Parameters",
               "as":"monitorUrl",
               "XPath":"/Parameters/Parameter[@name='URL']",
               "transform":"url"
            }
         ],
         "children":[
            
         ]
      }
   ]

Data streams standardize data from all the different shapes and formats your tools use into a straightforward tabular format.

While creating a tile you can tweak data streams by grouping or aggregating specific columns.

Depending on the kind of data, SquaredUp will automatically suggest how to visualize the result, for example as a table or line graph.

Data streams can be either global or scoped:

• Global data streams are unscoped and return information of a general nature (e.g. "Get the current number of unused hosts").
• A scoped data stream gets information relevant to the specific set objects supplied in the tile scope (e.g. "Get the current session count for these hosts").

See Data Streams for more information.