ctlswadmin ✭✭✭✭✭

What issues are you guys having CourtesyIT ?

This is kind of sloppy, but just looking to see if this is what you had in mind? Select Top 50 NodesData.Caption AS Name,Volumes.LastSync AS TimeStamp,CPULoad.AvgLoad AS 'CPU Usage(%)',CPULoad.AvgPercentMemoryUsed AS 'Memory Usage (%)',Volumes.DiskReads,Volumes.DiskWrites From Volumes Join NodesData ON NodesData.NodeID =…

dclick, You should be able to fix your query without much hassle. As you probably already know, the nodes table was broken into three different tables. I don't recall what table the caption (node name) was moved to, but to fix your query you should be able to update "Node ${Node.Name}" to the new table with the new column…

jayshree vispute​ has a good query that might give you what you need. You will just have to adjust the date parameter. Here's a link to his post: custom group query

Since not marked as answered, I assume the request is still valid. This adds IP to your query: SELECT N.NODEID AS "ID", 'N' AS "OBJECTTYPE", N.CAPTION AS "DEVICE", N.IP_Address AS "IP Address", N.OBJECTSUBTYPE AS "POLLING METHOD", (DATEDIFF(HH,(MAX(E.EVENTTIME)), GETDATE())) AS "TIME DOWN IN HOURS" FROM NODES N INNER JOIN…

Depending on your server configuration, based on licensing you should be able to run most of this on one server. I'm not familiar with patch manager, but for the rest of the modules all will work fine on one server. I do recommend installing your database on its own server. Do read the recommendations, they provide good…

I don't currently have this configured, but it might work for you: With the following trigger actions, you may have to play around with the variables to get the exact issue.

Hi Kkillens, What report are you working on specifically ?

Hi Deltona, I haven't played around with the UDT tables in a while now. Can you confirm if "Last Scan" is considered last seen ? That's the only date reference I found on njoylif's query. Are you using the same tables as they are ? If you're using the same query, or similar to add this to the end. LastScan >…

How did you create your group of nodes ? Created a group and assigned your nodes to that group, or created a custom property and tagged those nodes accordingly ?

I would personally direct users to the event manager and teach them to query the logs. If your vision is a requirement your best bet is SQL SSRS. Not sure if it's possible to have users define the node and have information reported back, unless you write custom reports for every switch you have and grant users to that…

Hey guys, I tried dynamic query groups but that didn’t work out. This is the way I configured my group, I created the parent group and then created other groups and implemented dynamic queries. Then I placed all of my dynamic query groups within the parent group. As I started adding more groups performance went down. To…

Hi Abmims, I assume that you're asking to add text to the body of an email. To accomplish this please follow the steps below: Step 1: Navigate to the Main Settings & Administration page Step 2: Under Alerts & Reports select Manage Reports Step 3: Select the Schedule Manager (It's to the right of Report Manager under the…

S-Bolyard, Give this a try: Use this variable to define free space. ${N=SwisEntity;M=SqlDatabaseAlert.TransactionLogFreeSpace} Thanks, David

Can you provide the syntax your using please.

Hi Gino, I am curious as to the status of your issue. I have similar issues in a larger environment and assumed that it was related to the network size. Do the mac addresses show in the mac address table of your host device? Also, what snmp version are you running ? Thanks David

Hey Sotherls, Is it safe to assume that all of your passwords are the same based on username ? Or is this the reason for seeking this report to find password typos. If your passwords always match the username, you could do a sql case statement around the username. I can write you up a query if you'd like, or if you just…

Try the query below, adjust the date parameter to filter the data. Select DateTime, UserName,Type AS Status, Action,Details From NCM_Audit Where DateTime < DATEADD(DAY,-14, GETDATE())

Hi Mark, I recommend that you adopt custom properties if you haven't already and use that as your foundation to create reports. Thanks, David

This should work if ran from Report Writer. Also, I replied to your previous post mentioned at the beginning of this post. SELECT N.NodeID AS Node_UniqueID, N.CoreNodeID AS Node_ID, N.AgentIP AS IP_Address, N.NodeCaption AS "Node_Name", CA.ConfigType AS Config_Type, CA.DownloadTime AS Download_Time,…

Build the new NPM box and install the exact same version of products you have. Once that's done bring your current NPM box off line, and stop all SW services on your APE's, go to the db and update your NPM server on the engines and engineproperties table, then truncate PendingNotifications, Subscriptions,SubscriptionTags.…

Hey aapelc, You can test connectivity between the servers using the required communication ports needed between NPM/APE/ SQL. This allows you to run through everything rather quickly without having to install the software for testing purposes. If you have the necessary permissions on the new servers you shouldn't run into…

Here are a few good articles that answer your question: https://thwack.solarwinds.com/docs/DOC-188643 https://thwack.solarwinds.com/message/236296#236296 If you still need assistance, let us know.

Hey sja, This query gives you interfaces that are at 65% or greater based on input/output numbers. SELECT n.Caption AS NodeName, i.Caption AS Interface_Caption, i.Outbps AS Xmit_bps, i.Inbps AS Recv_bps, i.OutPercentUtil AS Xmit_Percent_Utilization, i.InPercentUtil AS Recv_Percent_Utilization,…

This should do it. Once configured add the report to the report scheduler and have the report emailed to you at your requested intervals. The only thing you will have to change is the filter with the device you would like to monitor, if you have more than one device use other conditions to include the devices desired. Hope…

This should do the trick. Either run it against your db, or open Report Writer and select advance sql and paste it in there. Select Caption,IP_Address,StatusLed From Nodes Where Unmanaged like '1'

What version of NPM are you running?

Have you changed your retention policies ?

Doug, The best way to go about this might be custom pollers. Here's something quick I threw together to see if this is what you had in mind, I might be off on my approach here. Tested this on 11.5.3, should work on the .12 release. Select NodeName,SensorDisplayName,SensorValue,SensorUnit From APM_HardwareSensorAlertData…

Hi Sean, That value is derived from the Value column in the APM_ComponentTemplateSetting table. I don't think that every value is populated, it will only show if you've configured your component in a specific way. - David