The most recent content from our members.
Hey Guys, I recently had one of my customers ask for a report that displays all IP's associated to every device on the network. Figured I would share, there might be a canned report that accomplishes the same task, but for something this simple I just wrote my own query. (Faster than looking for the report). My customer…
ALL Wi-Fi Access Points Inventory Pending… Great News Fellow SolarWinds THWACK’sters… I have been fortunate enough to find a SolarWinds SQL Script within the THWACK Community that I have developed to ideally give us the items listed below for an ALL Wi-Fi Access Points Inventory. [BUT]. The ALL Wi-Fi Access Points…
Hello! We've created a report that can show us machines that do not have a particular set of patches by KB number (i.e. a compliance report) in SQL. Can we back convert it to a PM report, or can someone help us? The code is as follows: SELECT DISTINCT dbo.ComputerUpdateStatus.fulldomainname AS [Computer Name] FROM…
Hello I am very new to writing SQL queries, I have been tasked with creating a problem report to provide, Detail of the Triggered Alert (Alert Name), When the Alert was Triggered and count of times with in that period, I also would like to include columns for the Site and Device Type to which the device belongs. I found a…
I would like to see the reporting in WHD have a selection for creating custom reports based on SQL queries. This will give a broader range of reporting options for the system.
Hi all, I'm trying to find a way to convert a TOSTRING value to a number so that in my reporting I can display "order by" correctly and not in text. ,case when ack.timestamp is null then 'N/A' else tostring(minutediff(ah.TimeStamp,ack.timestamp)+0) end as [Minutes Until Acknowledged] Thank you! A
I'm new to running sql queries and I need to run a report that i believe it only can be done by sql query. this report will be use as View / dashboard. Can someone help me build a query that will return the following: - Node IP Address - Node Name - Node Group - Node Status (down only) - Time Node Down I really appreciate…
Hey Everyone, I've worked with SolarWinds quite a bit, but not so much with reports and charts. I've been asked a simple question: Can SolarWinds produce a chart like the one below? Suggestions on where to start would be very appreciated, and a pointer to existing content even more so. Thanks in advance!
Hi, I'm trying to export all tickets from WHD. I know how to export the current selection of tickets as a TSV. but this is limited to 100 tickets. Is there a way to export from the WHD database its self in a bulk fashion? Any advise would be greatly appreciated. *edit* I have tried the following.
I am trying to use the following SQL query to pull the date of the most recent archived running config and last time NCM successfully downloaded a running config: SELECT [dbo].[NodesData].NodeID, [dbo].[NodesData].IP_Address, [dbo].[NodesData].Caption, [dbo].[NodesData].UnManaged, [dbo].[NCM_ConfigArchive].DownloadTime,…
It looks like you're new here. Sign in or register to get started.