A user asked if it was possible to automatically capture user data from endpoints, store it in a csv located in a central shared location, and present it using PowerBI. Both Wouter and someone else responded to confirm that this is possible, though code cannot be shared from outside a customer’s environment. The best suggestion is to create a scheduled trigger or a user logon trigger to continuously capture data and aggregate it into one master csv.
Read the entire ‘Automatically Capturing User Data from Endpoints’ thread below:
I am looking to achieve the following scenario but wanted to check if it’s doable using CU:
• A script that runs all the time against a subset of endpoints and collects some data locally and saves it in a CSV file
• another script that runs hourly that goes and collects the data from the CSV file above and dumps it in a central shared location to be presented for instance using PowerBI
Is this doable? or perhaps is there a better way to do this?
P.S. the data I am after is not collected natively by CU
Cheers
I do this all the time with customers and it’s rather basic scripting. Sadly I can’t share the code for these as I don’t have it outside of the customers environment.
As wouter said this is a very common ask, most people just use exports on the monitor and just ingest it in powerbi, but export-cuquery would achieve the same thing but you can target specific columns if you dont want all of the extra data
Thanks both – the aim is to automate it end-to-end so you don’t have to “trigger” or “export” manually. I am fine with scripting just need to explore a bit on best ways to leverage triggered actions using CU. I want to continuously capture data per session (available in user context) as long as a session is established then aggregate data from all endpoints into one master csv to be consumed by PowerBI. what trigger event would you use for such to cover reconnection/fresh sessions? user logon? Cheers
Whatever you need to have it respond to. If you need the data like every 5 minutes you can also use a scheduled trigger.
Continue reading and comment on the thread ‘How to Collect and Transfer Non-Native ControlUp Data for PowerBI Visualization?’. Not a member? Join Here!
Categories: All Archives, ControlUp Scripts & Triggers