The Report Manager extension permits users with Administrator privileges to create, modify, and download reports about sessions, session connections, session connection events, and session events. To access the report manager, install the extension and select Report Manager under the Extras dropdown on the Admin page. Please note that this feature is only available for ScreenConnect 5.5 and above.



The Report Manager comes preloaded with four example reports.

Report names and definitions are saved in the SavedReport extension setting, which is accessible by selecting Edit Settings from the extension Options dropdown menu:



To create a new report, click New and enter a name for the report.

1) Aggregation Type

The report manager requires that you select an aggregation type before continuing to build a new report:



Ungrouped reports output all rows that meet optional filter criteria and include columns in a set of chosen select fields. Grouped reports combine rows into groups based on a set of selected group fields and optional filter criteria. Please note that you must select at least one group field to run a grouped report.

2) Report Type

Once you’ve selected an aggregation type, the report manager presents four report type options:

• Session reports include data about Support, Meeting, and/or Access session properties; for example, session name, guest activity and machine properties, and cumulative host and guest connection durations.
  
• Session connection reports include data about session connection properties; for example, the name of the session to which a connection was made and timestamps of connection and disconnection events.
  
• Session connection event reports output data about the following connection events: Connected, Disconnected, RanCommand, SentMessage, SentPrintJob, ReceivedPrintJob, CopiedText, CopiedFiles, DraggedFiles, RanFiles, and SentFiles.
  
• Session event reports output data about the following session events: CreatedSession, EndedSession, InitiatedJoin, InvitedGuest, AddedNote, QueuedReinstall, QueuedUninstall, QueuedInvalidateLicense, QueuedWake, QueuedCommand, QueuedMessage, QueuedGuestInfoUpdate, QueuedTool, ProcessedReinstall, ProcessedUninstall, ProcessedInvalidateLicense, ProcessedWake, ProcessedCommand, ProcessedMessage, ProcessedGuestInfoUpdate, ProcessedTool, ModifiedName, ModifiedIsPublic, ModifiedCode, ModifiedHost, and ModifiedCustomProperty
  

3) Group Fields

Group fields are the basis upon which rows are combined, and are available only if the grouped aggregation type is selected. The selected report type determines which group fields are made available:



For example, suppose I wish to create a grouped session connection report. The selected group fields shown above will group the outputted session connections according to the name of the session to which a connection was made and the date on which the connection was made.

4) Select Fields

Select fields optionally determine which columns are included in the report. Again, the selected report type determines which select fields are made available.



For example, a session report with the chosen select fields shown above will include columns describing session name, session type (i.e. Support, Meeting, or Access), and the date and time the session was created.

5) Filter

For ungrouped reports, only rows satisfying the filter criteria are outputted. For grouped reports, only rows satisfying the filter criteria are included in the aggregation.

6) Aggregate Filter

The aggregate filter is only applicable to grouped reports. Only grouped report rows that meet the aggregate filter criteria are included in the output.

7) Item Limit

Item limit specifies the maximum number of records returned by running the report.

Disclaimer: This extension was written by our support team (and in some cases in conjunction with our forum community) in response to customer requests. Extensions are meant to be quick workarounds or immediate solutions to problems. Extensions are not supported under our normal terms of service, as these extensions are outside typical Q/A or development guidelines. Questions for extensions should be addressed in its respective forum post. Suggestions for improvements (enhancements or defects) should also be queued in the post for consideration.

Edited by user Wednesday, January 13, 2016 4:14:23 PM(UTC)  | Reason: Not specified

im trying to make a report based on a user wanna see how much and when he loges on how can i get the report ?

After an Admin makes a report, Is there a way to make the url generated under "Run Options" available to non-admin users?

Hi!

Time in reports shows in GMT +00:00 time zone, but I need it in GMT +03:00 time zone. Time on server is correct. How I can fix this to show correct time in reports?

I have my report giving me the data that I want I would love for it to only show me %CurrentDate%, instead of all days in the month. I think it would be an aggregate filter but I can't seem to figure out what the syntax is.

Currently have a Grouped Session Connection Report with 7 Group Fields.

Filters: ProcessType = 'Host' AND SessionSessionType = 'Access'

Aggregate filters:


Thanks!

All the Examples use HostDurationSeconds as a Field name (using example gives 500 error), but it's listed as DurationSeconds in the Fields chooser?

Report Manager v1.7.1 is available now.

Filter and AggregateFilter examples should correspond to saved report types after launching the Report Manager.

...for those looking for Report Manager under 6.x like I was, it's under your User name icon in the bottom left after logging in.

To generate the requested information, you'll want to define and execute a SessionConnection report using the Report Manager extension.

The report definition will look something like this (the following assumes that all assets for a particular client have CustomProperty1 equal to 'ClientIdentifier'; just modify the filter to suit your needs):

Aggregation Type: Ungrouped
Report Type: SessionConnection
Select Fields: SessionName, SessionHost, ProcessType, ParticipantName, ConnectedTime, DisconnectedTime
Filter: SessionCustomProperty1 = 'ClientIdentifier'

If you wanted to get all session connections where the connection occurred on or after January 1, 2017, you could use the following filter:

SessionCustomProperty1='ClientIdentifier' AND ConnectedTime >= '2017-01-01'

Once you've defined the report, you can run it by selecting Run Options -> Download Report.

The aforementioned report definition looks like this in Report Manager:

At this time, the Report Manager is unable to get/append capture download urls; however, two other extensions provide alternative methods to download session captures:

1) Batch Audit Recording Downloader: Download an exe to batch transcode and download session audit recordings (requires .NET 4.0+)
More information available here: https://help.screenconne...dit_Recording_Downloader and http://forum.screenconne...ecording-Downloader.aspx

2) Query Session Recordings: Accessible from the options menu of this extension, or the Extras menu on the Audit page. Get a list of Session Recordings with option to download. Can filter by Session ID or Session Name and a Date Range. (Requires 5.3+)
More information available here: http://forum.screenconne...-Session-Recordings.aspx

Is Report Manager compatible with 6.2?

When clicking on the Report Manager menu link, nothing happens for me in versions:

6.2.12811.6295
6.2.12886.6302

Thanks!

Is it possible to create a report that includes data about the idle time for each machine? Ideally we'd like to be able to see the average idle time for each guest device in an access session over x period of time to help determine which computers are underutilized

Thanks for the idea Ben. We're running Cloud version 6.2.12963.6312 and I'm not seeing the GuestInfoRefreshSeconds or GuestLastActivityTime option - is that premise only or has that maybe changed?

Edited by user Tuesday, May 9, 2017 6:09:01 PM(UTC)  | Reason: Not specified

Hello,

I didn't see a field for the BIOS version, so I thought I would ask the following. Is it possible to pull the BIOS version from all the machines and get a report for that? Or is there a better way to get this information?

We have a bunch of Access machines and want to find the BIOS version so that we can update them.

@silversword is correct, the Additional General Information extension is responsible for populating that data, but it's basically just sending a specifically-formatted command to retrieve it.

You should be able to pull an Ungrouped report on it by SessionConnectionEvent, selecting the Data field (and maybe SessionID to make it easier to identify). In order to only include the command we want, your filter should look like:



Here's an image to make it clearer:

By default, organisation is the name for custom property 1.

If you want to include organisation in your reports, simply select the CustomProperty1 field for a Session report or the SessionCustomProperty1 field for a SessionConnection or SessionEvent report.

Hi Cooper,

I generated a similar report and was able to get a bit more information than your screenshot displays.






I think you may just need to expand the height of the row to find the information you are looking for, but please let me know if that doesn't solve your problem.

Good morning,

While it's currently not possible to schedule recurring emails of the requested information, you can generate a session connection report that includes the desired info:

Aggregation Type: Ungrouped
Report Type: SessionConnection
Select Fields: ParticipantName, SessionName, ConnectedTime, DisconnectedTime, DurationSeconds
Filter: ProcessType = 'Host' AND ConnectedTime >= '2017-09-06 04:00:00' AND ConnectedTime <= '2017-09-07 04:00:00'

Please note that all time comparisons are conducted using UTC timestamps (the example above depicts UTC to EDT conversion).

Cheers,
Ben

Hi,

I'm trying to pull a report for each machine that displays how long a machine (guest) has been connected in a given month. We have "spare" machines that are not billed unless they are in use, and want to use a report to determine if a machine was "in use" during a month. (The machines are shut down when not in use, so will show as offline in CWC)

Failing that, a report that shows the last time a guest was connected would work as well. I have tried using LastConnectedEventTime, but the report manager does not seem to cooperate with this filter.

Hi Ben,

Option 1 does exactly what I need. Thanks you for the assistance!

I did apply a couple minor tweaks to groom the results a bit further, here's my final report for the curious:



After converting seconds to days, and hiding the session-id (I'm only using this field to correct duplicate names), here is what I get:

Are you using an on-prem Linux server?

We previously identified an issue that affects the underlying reporting api on mono-based servers on version 6.4 (the Report Manager extension makes use of the reporting api). The fix is in place, undergoing QA, and should be available in the next release of Control.

I wish ConnectedTime could use a variable such as >= $1DAYSAGO.

If the filter took a variable of that nature, I could potentially write a script to pull the JSON data response from the Report URL and send it directly into slack to each of my techs. I'd still have to setup a separate report for each of my participants with a filter, but the base would be the same so i'd just have to edit the participant filter and each report would have its own URL I could use the script to pull data from.

The need really is for a daily report for each of the participants but with the date's being static you have to login and update the report every day. :(

Could I potentially generate a report with an API Call? I could script something that requested essentially the same report the report manager has saved but use the scripting mechanism to supply a current date via the API?

I'm really just thinking out loud here as it would be great to automate emailing a daily report or sending it to Slack.


Edit:
So I took a report I had for the daily activity in .csv format and changed the dates in the URL and it downloaded the .csv with the dates requested, so I can probably get what I need by scripting something to request data from a generated custom url and get what I need that way.

Edit #2:
In the end, I was able to write some Scripts in Automate that would query mysql to get a time stamp that matched current UTC time and current UTC time minus 24 hours and export them in the format required by the URL. I used those as variables in the URL (so they would generate as current time anytime the script executes) as well as a variable for ParticipantName in the URL. After having to do a little bit of text clean up in the scripts (convert spaces, greater than, less than, colon to their %equivalent) i was able to pass the URL to Slack via Powershell from the Automate server and schedule my scripts accordingly. Now everytime the script runs it sends a URL to the team members slackbot so they are the only one to receive the message and the URL is formatted to request a .csv file for that user for the last 24 hours.

Edit #3:
All worked well with stuff from Edit #2 except when my end users received the URL, they click on it and it prompts them for credentials to the SC Site. Turns out if they don't have an Admin account on the SC Server they can't download the generated report.

Upvote: Allow non-admins access to Report Manager (Feature Request)

Edited by user Thursday, December 21, 2017 7:37:31 PM(UTC)  | Reason: Adding Additional Information

"Report Manager extension permits users with Administrator privileges"

I'm wondering if there is any 'UserEcho' request for that.

I'm asking this, because there is not any 'active' SC admin and they don't even use report at all.

I'm the guy who brought SC to my Company and I want to push for myself to have/use this report, even when I don't have SC admin level, and I probably won't in the near future.

I do many reports for my Support team, and this will help a lot. Then, if this is possible, I will ask within my organization to have it.

As example: we are getting big balloon for pcs quantity, far more than 100 I believe are dead/ghost/cloned sessions, and nobody will purge those.
Getting into the report menu, I could probably pull this out, and report this or even purge myself, since I can do it manually.
Also, for inventory control as well and other reasons.

1-I do really want to follow up on this topic, do someone know if there is any topic already? or how can I look for this topic on 'UserEcho'?
2-Where can I find out on details what can I do with reports? customization and others?

Thanks

Edited by user Friday, April 20, 2018 9:20:34 PM(UTC)  | Reason: Not specified