Community Discussions
Explore the latest discussions and community conversations related to this domain.
Get Quick Report data via REST API call
Main Post: Hi all,I’m trying to GET the content of a Quick Report using the REST APIs. I can see the endpoints in API Explorer; but when I make the request in Postman, although the status code is 200, the payload is an empty array (see image).I’ve tried this with a couple of different endpoints:https://.../projection/v1/QuickReports.svc/QuickReport_36969() https://.../projection/v1/QuickReport36969.svc/VirtualOrderSqlReportsBoth give the same result. I’ve also tried with a couple of other Quick Reports - it’s not just that one.The endpoints are showing as ‘Active’ in API Explorer (and presumably I’d get an error if they weren’t anyway). Is there something else I need to do to ‘activate’ the APIs? The Quick Reports themselves are generated from an SQL statement, if that makes a difference (and to confirm - if I view the report directly, there is plenty of data to see!).
Top Comment: Hi all,I’m trying to GET the content of a Quick Report using the REST APIs. I can see the endpoints in API Explorer; but when I make the request in Postman, although the status code is 200, the payload is an empty array (see image).I’ve tried this with a couple of different endpoints:h...
Compliance report using PACLI or REST.
Main Post:
Hello all, I'm looking for a way to automate sending compliance reports to a distribution list. Currently, I scheduled a compliance report for accounts that are going to expire in 7 days. Does anyone know a way to generate this report via PACLI or REST? I read the documents but, I didn't find anything specific for compliance report. I believe that PACLI can search files and possibly can filter them but, not sure what would be the filter to find accounts that are going to expire in 7 days. Any help would be much appreciated.
CyberArk version: 9.8
-mz
Top Comment:
I'm pretty sure you can schedule this via PVWA, check the reports tab I think it's the last screen when you are generating a report.
Need Help in exporting data from report with REST API
Main Post: Need Help in exporting data from report with REST API
REST API equivalent for Power BI Report Server
Main Post:
Hi guys, I’m looking for some kind of Powershell/python (or anything for that matter) script which will trigger a dashboard refresh on the on-prem Power BI server. Currently, the dashboards/reports have scheduled refreshes, the problem being that the ETLs haven’t always completed in time for the scheduled refresh. Any assistance will be appreciated.
Top Comment: Does the section here on running a single subscription help? I recall subscriptions for PBIRS reports are similar to traditional reports but not sure if the approach to manually refresh them would be the same: https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/manage-subscription-owners-and-run-subscription-powershell?view=sql-server-ver15#bkmk_run_1_subscription
Kawhi Leonard (rest) not on injury report Wednesday.
Main Post:
link
Top Comment:
That’s huge
Report: Joseph Tsai to buy rest of Nets for $2.35 billion
Main Post: Report: Joseph Tsai to buy rest of Nets for $2.35 billion
Top Comment:
His investment is going to increase by a lot. Smart guy
Panthers injury report: Chuba(rest) DNP, Diontae Johnson(ankle) DNP, Jonathan Brooks(knee) LP
Main Post: Panthers injury report: Chuba(rest) DNP, Diontae Johnson(ankle) DNP, Jonathan Brooks(knee) LP
Top Comment:
I’d be concerned if Dionate wasn’t on the injury report tbh
generating a report based on hosts in a server class
Main Post:
OK.....Heres the setup.
- Server 1 - indexer (Splunk 6.5.3)
- Server 2 - searchhead (Splunk 6.5.3)
- server 3 - deployment management (Splunk 6.5.3)
We have an application that runs on several host (about 20~30, Win 10 with forwarder configured to use deployment server). Due to system name, they are automatically added to a server class and the appropriate app is pushed into the configurations for get text log file.
When we started, we thought it would be good to create an alert based on a query that gives a list of systems that the application log has not had anything new for more than 6 minutes. (The application does many things on a timer that get written to the log every few minutes...ie, if no new text in the logfile after X minutes, it must be in the weeds). The report runs every few minutes and, if there are clients in the report, emails me . . seems legit enough. and to be honest it has helped me find problems before users.
Well we had to replace a few clients due to a hardware problem and they are now stuck on the list. Logically it make sense why that happened, there has been no log entry (and logfile or system) for more than 5 minutes....like 80,000 minutes. I want to rebuild my report query to get its list of host from the serverclass client list instead of the index="appPCsIndex", but i cant figure out how to search for a list of hosts by serverclass association.
I hope this makes sense. Thanks
Top Comment: try running this search on your forwarder management server: | rest /services/deployment/server/clients splunk_server=local | search serverClasses..stateOnClient=enabled | stats values(hostname) If the 'hostname' field values don't look right, try 'instanceName'. If you need more .csv friendly output, you can do this instead of the "| stats values(hostname)": | dedup hostname | table hostname | sort hostname