Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Number of CPU Core SQL report

Number of CPU Core SQL report

Table of contents
Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 250 Votes: 2 Revisions: 5

Overview

This article provides steps to build a number of CPU Core SQL report.

Environment

NPM version 11.0 or later

Steps

1. Open the Orion Report Writer.

2. Click Start > All Programs > Solarwinds Orion > Advanced Feature > Report Writer > New.

 

3. Name The Report  as required.

4. Click on SQL Tab > Paste the below SQL Query.

5. Select N.Caption, IP_Address,   Status,  COUNT(DISTINCT CPUIndex) As "Number Of Cores"
FROM CPUMultiLoad_Detail CPU WITH(NOLOCK)
JOIN Nodes N ON CPU.NodeID = N.NodeID
GROUP BY
N.Caption, IP_Address,  Status 
Order By
N.Caption, IP_Address,  Status  

 

6. Go to Fild Formatting Tab > Select the below option.

 

7. Click Preview.

 

Last modified
23:14, 22 Jun 2016

Tags

Classifications

Public