How to get Usernames and Login Time Data via ControlUp Insights or Triggers

A user inquired about the best way to create a report using Insights which includes usernames and login times to a CSV on a network location. The suggestion was to use an Export Schedule in Monitor config or build a trigger that fires an export when logon duration is higher than a certain amount of time, or use export-cuquery. Historical data is only available in Insights/Solve and Outlook macros can be used as a workaround.

Read the entire ‘Getting Login Time Data via Insights or Triggers’ thread below:

Looking for some direction on a report from Insights, didn’t see a good place to post about insights so I thought this was the next best.

In Insights under Sessions – Resources I can click "Automate" and run a schedule job to email a csv to me of the data I need. Is it possible to do this another way and save the CSV to a network path, possible form the real time console, triggers?

We are trying to get a report of usernames and login times and export to a CSV on a network location, thanks in advance.

You can use an Export Schedule in Minitor config or built a trigger when logon duration is higher than x sec which can fire an export.

https://support.controlup.com/docs/export-settingsI was not clear on the trigger 🙂

You can setup an trigger with „if Logon Suration is greater than x sec“ you can use as follow-up action „Dump Views to Disk“ to get an export from a view from RealtimeDXYou could schedule the report via insights but only option is to get it via email . You could save it to disk only from triggers …

But if you want it on a nas share then probably need to do sone customization by using script which would directly query the DB and get the required information

Or use export-cuquery on a monitor to get just the fields you are interested in. The issue with that though is its a snapshot in time and not a report over time. https://support.controlup.com/docs/export-cuquery

@member The Export Schedule function or creating a live trigger, no way to see historical data like reported from Insights, specifically username and login time for the last 6 months?

If you just need username and Logon Time, the User Sessions Activity report in insights or solve gives you just that and more.

Historical data is only available in Insights/Solve and there is nothing I can think of.

Maybe you can workaround this with an Outlook macro:

https://www.extendoffice.com/documents/outlook/3747-outlook-auto-download-save-attachments-to-folder.html

Haven’t tested it though 🙂

Thanks All!

Continue reading and comment on the thread ‘How to get Usernames and Login Time Data via ControlUp Insights or Triggers ‘.  Not a member? Join Here!