The most recent content from our members.
I am building a SWQL query to grab MAC address and SerialNumber from MikroTik devices. We have it mostly working, but I am struggling getting the query to properly pull the SerialNumber from the Universal Device Poller we have set up. Normally, I would simply grab the ServiceTag from the database, but these devices do not…
I'm trying to make a report that excludes 1 or 2 specific categories / subcategories, and right now the only way for me to do that is to select every category except the ones I want to exclude. The bigger problem with this is that if we later add categories, I have to remember to add the new categories to this report. It…
Request to use a certificate thumbprint for scheduled reports when SSL is enabled. Background: We use scheduled reports, but we recently enabled SSL which broke the process. The exporttopdfcmd.exe, which runs the reports, currently uses a file path to the certificate which allows the scheduled reports to work with SSL…
SQL Server Reporting Services (SSRS) is a little gem of the SQL Server stack, under-appreciated, but a gem nonetheless. Building a report is relatively simple, and lots of people do this. As part of the SQL Sentry suite of tools, we have a number of reports that are built-in. But what not many people realize is that we can…
Within the SQL Sentry tools, we have a number of built-in reports that can be run. Either via the reports menu or as Quick Reports from the performance dashboard. Recently I have spoken with a number of customers, and the feedback is that their management really like the reports. However, they were asking if there was a…
It would be helpful if reporting options and filtering were more granular, to align the same reporting capabilities of exporting and scheduling from all reporting/auditing sections across the entire service desk account, and not just from the reports section. Specifically, having the and ability to export from task views,…
Please update/expand 1- Power Bi connector for pulling full scope of account data 2- Data/Web API further defined, allowing data to be connected in Power Bi Desktop via Web URL. (1) I believe it would be most beneficial to all SW customers using the PBi connector, for it to pull raw data at the individual account level so…
Add more fields to the native PowerBI connector for integrations so we can get better reporting. Specifically Tasks data from Incidents. After expanding the task column in the incidents table, we are only seeing the task number. We would like to see more information regarding tasks such as the task owner, task open and…
Hello, I am in need of help on creating a Report that would show a count of Downs for an Application per Server. I have no clue what the Query would be for something like this :) Basically, just a Custom Table that would look similar to: Server Name | Count of Downs vmserver1 | 5 vmserver2 | 3 Thank you for any help on…
Hi, As part of our regular reporting process, we are pulling a report from solarwinds for node CPU, MEMORY and DISK Utilization data. We are now working to automate this process using SWQL queries. However, when attempting to extract historical data via SWQL, the queries are returning no results(giving errors) We would…
It looks like you're new here. Sign in or register to get started.