The most recent content from our members.
@KMSigma.SWI I didnt find any Linux resource reports on Report LAB. I need to run reports on CPU/MEM/DISK for Linux SUSE servers. I am using linux agent to monitor my servers. Dont have SAM as yet. Also need to do same for modern dashboards. Any help will be appreciated. thnak you,
Hi, Can anyone help me to tweak a report using SWQL/SQL query? I need to extract all the Top 25 Interface Utilization with 90/95/99th Percentile Traffic every 2 hours? SELECT Interfaces.InterfaceId ,Nodes.NodeID ,Nodes.Caption AS NodeName ,Nodes.DetailsUrl AS NDetailsUrl ,Nodes.VendorIcon AS Vendor ,Interfaces.Caption AS…
I'm having trouble find the right SWQL to add the current values of two custom pollers to a report. The query I've been working with: SELECT ONPMC.Node.Caption, ONPMC.Node.IPAddress, ONPMC.Node.IOSImage, ONPMC.CustomPollerName, ONPMC.AssignmentName, ONPMC.CurrentValue AS FlashSize FROM…
Hi All ! I am using mute alert report that is written in SWQL. (Pasting the code below). My requirement is that we should have a comment field (lets say i can request users to write that in Notes field why did they put it in mute alerts). And then the notes field is also displayed as additional column. Currently the code…
I want to create a SAM report that will show all assigned Application Templates and a list of Alerts that each assigned Application Template could trigger. Also, keep in mind that each monitoring component in the Application Template could trigger different Alerts. This is probably very simple. But I’m getting a brain…
I am trying to write an SWQL query that uses a CTE WITH clause. I know it should be possible as I've found many examples on Thwack showing that it's possible. For the life of me, I cannot get any of the examples to work in either SWQL Studio or the web-based Report Writer. When I run an example I get the errors "mismatched…
Hello, The request: A customer is asking if we can provide an overview of all users that connected to an AP associated with a particular Wireless controller for last week, containing: - Date/hour connection was made - Wi-Fi AP - SSID used - Name and first name of the person (username) - Client IP address My approach: I…
When preparing a custom table, in the data source picker dialog, there is an option to report on "IP SLA VoIP Jitter Operation View". This specific data source contains two columns called "AVG JITTER" and "MAX JITTER" for each row, as well as a "SUMMARY DATE" which indicates for which day these values are for. It is clear…
First off thank you to wluther and his posts that led me in the right direction to create this, as well as mesverrum for his query on node outages. This is a custom HTML resource that uses SWQL queries, Javascript and Google charts to create interactive charts that allow for great customization. Here is a screenshot of…
Hello, I am trying to put together a server report using SWQL. I do not have any documentation on tables/field names so I am flying blind. I need items 7,8, 9 in the swql statement below. Can anyone help me? * SELECT * n.NodeID, * n.DisplayName, * n.IPAddress, (Delete) * n.MachineType, * n.Interfaces.DisplayName AS…
It looks like you're new here. Sign in or register to get started.