logo

The ConnectWise Control forum has moved to ConnectWise University! This forum has been locked and is in read-only mode. Click here for instructions on how to access the new forum.

Welcome Guest! You can not login or register.

Notification

Icon
Error

Options
Go to last post Go to first unread
jayH  
#1 Posted : Tuesday, May 19, 2015 8:45:46 PM(UTC)
jayH


Rank: Newbie

Joined: 5/17/2015(UTC)
Posts: 6

So we have SC deployed to multiple clients via a GPO. The issue I am faced with is, every day I see more computers being added to the all Access group. This is due to users rebooting their computers and the policy is installing the software. However, I need to run some kind of report to see which computers were recently added to which access group. I think this kind of reporting should be standard but I haven't seen it anywhere. Any help would be appreciated.

jayH  
#2 Posted : Wednesday, May 20, 2015 8:14:14 PM(UTC)
jayH


Rank: Newbie

Joined: 5/17/2015(UTC)
Posts: 6

Looking for something along these lines. PUN INTENDED!




SELECT Name, GuestLoggedOnUsername,
GuestLoggedOnUserDomain, GuestOperatingSystemName, GuestProcessorName, GuestSystemMemoryTotalMegabytes, min(sce.time) as StartTime, max(sce.time) as EndTime, s.customproperty1,
round(((julianday(max(sce.time)) - julianday(min(sce.time))) * 24 * 60),2) as "Time Connected (min)"
FROM SessionConnection sc
INNER JOIN SESSION s ON s.sessionid = sc.sessionid
INNER JOIN sessionconnectionevent sce ON sce.sessionid = s.sessionid AND sc.connectionid = sce.connectionid
WHERE sc.ProcessType = 1 AND (sce.EventType = 10 OR sce.EventType = 11) AND (s.SessionType = 2 OR s.SessionType = 0) and sce.time >= date('now', 'start of month')
GROUP BY s.name, sc.ParticipantName, s.GuestLoggedOnUsername, s.GuestMachineName;
Alexander  
#3 Posted : Thursday, May 21, 2015 5:45:50 PM(UTC)
Alexander


Rank: Administration

Medals: Level 3: Shirt off your back! Received 25 Thanks!

Joined: 7/23/2013(UTC)
Posts: 715
Man
Location: Raleigh, NC

Was thanked: 66 time(s) in 63 post(s)
First off, just to clear this up: computers aren't added to a specific session group; session groups are just filters. So when a computer connects with the access client, it appears in All Machines, and it also appears in any other session groups that match it.

You probably want to look at the CreatedSession (20) event, so something like this:
Code:
SELECT Name[, …]
FROM Session s
INNER JOIN SessionEvent se ON se.SessionID = s.SessionID
WHERE se.EventType = 20 AND s.SessionType = 2 AND se.Time >= [recently]
ScreenConnect Team
jayH  
#4 Posted : Thursday, May 21, 2015 5:52:05 PM(UTC)
jayH


Rank: Newbie

Joined: 5/17/2015(UTC)
Posts: 6

Originally Posted by: Alexander Go to Quoted Post
First off, just to clear this up: computers aren't added to a specific session group; session groups are just filters. So when a computer connects with the access client, it appears in All Machines, and it also appears in any other session groups that match it.

You probably want to look at the CreatedSession (20) event, so something like this:
Code:
SELECT Name[, …]
FROM Session s
INNER JOIN SessionEvent se ON se.SessionID = s.SessionID
WHERE se.EventType = 20 AND s.SessionType = 2 AND se.Time >= [recently]


How would i include this in my previous post? Im so not familiar with all this and only got here after trial and error for a full day. Ay help is appreaciated
Alexander  
#5 Posted : Thursday, May 21, 2015 7:23:07 PM(UTC)
Alexander


Rank: Administration

Medals: Level 3: Shirt off your back! Received 25 Thanks!

Joined: 7/23/2013(UTC)
Posts: 715
Man
Location: Raleigh, NC

Was thanked: 66 time(s) in 63 post(s)
I'm not sure what you mean… You want to combine the two queries somehow?
ScreenConnect Team
jayH  
#6 Posted : Thursday, May 21, 2015 7:24:48 PM(UTC)
jayH


Rank: Newbie

Joined: 5/17/2015(UTC)
Posts: 6

Originally Posted by: Alexander Go to Quoted Post
I'm not sure what you mean… You want to combine the two queries somehow?


Yes
Alexander  
#7 Posted : Thursday, May 21, 2015 7:41:58 PM(UTC)
Alexander


Rank: Administration

Medals: Level 3: Shirt off your back! Received 25 Thanks!

Joined: 7/23/2013(UTC)
Posts: 715
Man
Location: Raleigh, NC

Was thanked: 66 time(s) in 63 post(s)
What exactly are you trying to get?
ScreenConnect Team
jayH  
#8 Posted : Friday, May 22, 2015 3:08:46 PM(UTC)
jayH


Rank: Newbie

Joined: 5/17/2015(UTC)
Posts: 6

Originally Posted by: Alexander Go to Quoted Post
What exactly are you trying to get?


Im trying to get a report of which computers were recently added to which session group. I keep seeing the all machines number go up but i would like to know which group it actually got attached to.
Alexander  
#9 Posted : Tuesday, May 26, 2015 3:42:26 PM(UTC)
Alexander


Rank: Administration

Medals: Level 3: Shirt off your back! Received 25 Thanks!

Joined: 7/23/2013(UTC)
Posts: 715
Man
Location: Raleigh, NC

Was thanked: 66 time(s) in 63 post(s)
Session groups are defined with a SQL-like syntax, so you can put that in a WHERE clause to filter for sessions in a specific group. Getting which group is trickier, though, since session groups are not inherently mutually exclusive; depending on what session groups you define, a given session could potentially be in all of them at once, or just in "All Machines" and nothing else. If there's something about your session groups that makes them mutually exclusive, that's probably what you'd want to look at.
ScreenConnect Team
Users browsing this topic
Similar Topics
reports for machines (General Information)
by toddalex2000 8/25/2018 2:26:16 AM(UTC)
Bug Reports Forum Moving (Bug Reports)
by Sean 11/4/2016 6:14:35 PM(UTC)
There exists even now very little reports related to the price tag on your Nike (Tips and Tricks)
by lebron251 3/4/2015 7:37:00 AM(UTC)
Screenconnect Client reports as virus (Bug Reports)
by madisonave 1/15/2015 7:28:46 PM(UTC)
Detailed reports (Feature Requests)
by HavenZone 1/7/2015 9:18:42 PM(UTC)
How to generate reports from access session groups? (General Information)
by porterraliegh 12/16/2014 6:01:06 PM(UTC)
Access to database for auditing reports (General Information)
by chh 11/10/2014 10:43:25 AM(UTC)
Need better audit reports (Feature Requests)
by mkhan 2/20/2014 9:28:47 PM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.