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
Aaron  
#1 Posted : Wednesday, February 26, 2014 3:58:09 AM(UTC)
Aaron


Rank: Advanced Member

Joined: 11/9/2013(UTC)
Posts: 64
Location: USA

Was thanked: 1 time(s) in 1 post(s)
How would I create a session group for clients that haven't connected in 7 days?

Thank you!

Edited by user Wednesday, February 26, 2014 3:58:46 AM(UTC)  | Reason: Not specified

Jeff  
#2 Posted : Friday, February 28, 2014 4:31:33 PM(UTC)
Jeff


Rank: Administration

Medals: Level 4: Wise Old Owl! Received 100 Thanks!

Joined: 4/14/2010(UTC)
Posts: 1,785
Man
Location: Raleigh, NC

Thanks: 8 times
Was thanked: 156 time(s) in 122 post(s)
Checked on this and that is not possible at this time. You could set some sort of a date to do a manual filter and modify the date as required.

GuestLastActivityTime > '2014-01-01'

But I will put in a feature request on your behalf.
ScreenConnect Team
igor  
#3 Posted : Monday, March 3, 2014 4:43:57 PM(UTC)
igor


Rank: Advanced Member

Joined: 7/2/2013(UTC)
Posts: 30
Canada

Thanks: 4 times
+1
Harti  
#4 Posted : Wednesday, August 2, 2017 6:59:22 AM(UTC)
Harti


Rank: Guest

Joined: 3/29/2017(UTC)
Posts: 1
Austria
Location: Vorarlberg

+1
Mike  
#5 Posted : Wednesday, August 2, 2017 5:58:55 PM(UTC)
Mike


Rank: Administration

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

Joined: 5/30/2012(UTC)
Posts: 501
Location: Raleigh, NC

Thanks: 56 times
Was thanked: 82 time(s) in 68 post(s)
Hi Harti,

This is an old post. We've added some time variables in the session filter that should be helpful.

Code:
$NOW	The current time but rounded down to the hour. This variable is rounded down to prevent constant recalculation.

$XDAYSAGO	$NOW minus X days. Returns a date. Replace “X” with any integer


To answer the post you can use the session filter.

GuestLastActivityTime > $7DAYSAGO

Here's a link to the KB for more information: https://docs.connectwise..._groups_filter_reference
ScreenConnect Team
jorylane  
#6 Posted : Monday, August 14, 2017 3:47:21 PM(UTC)
jorylane


Rank: Newbie

Medals: ScreenConnect Advisor: Focus Group Member

Joined: 3/13/2014(UTC)
Posts: 8
Canada
Location: Toronto

Thanks: 1 times
Originally Posted by: Mike Go to Quoted Post
H

$XDAYSAGO $NOW minus X days. Returns a date. Replace “X” with any integer[/code]

To answer the post you can use the session filter.

GuestLastActivityTime > $7DAYSAGO


Thanks for this! I have added a session group with a filter:
GuestConnectedCount = 0 AND LastConnectedEventTime < $180DAYSAGO

However it doesn't seem to be accurate, as I can see it contains a number of machines that show Idle Times of far less than 180 days. I also see that many of these machines are blank under the field "Guest Last Connected:", so I'm using the Idle Time field as my closest point of reference. Is the problem here that the Idle Time is a completely separate field from Guest Last Connected? And thus, if the Guest Last Connected field is blank, the data will be inaccurate?

If I'm correct on the above, what about the ability to filter by Idle Time instead?

Thanks,

Jory

jorylane  
#7 Posted : Monday, August 14, 2017 4:00:55 PM(UTC)
jorylane


Rank: Newbie

Medals: ScreenConnect Advisor: Focus Group Member

Joined: 3/13/2014(UTC)
Posts: 8
Canada
Location: Toronto

Thanks: 1 times
Ok I figured out that by using: GuestInfoUpdateTime < $180DAYSAGO
I get what appears to be an accurate result based on the "idle" time of the machines I referenced in my last post.
ScreenConnect team: Let me know if that makes sense as a "workaround". Thanks.
Michael L  
#8 Posted : Monday, August 14, 2017 6:07:29 PM(UTC)
Michael L


Rank: Administration

Medals: Level 1: Random Act of Kindness! Received One Thanks!

Joined: 8/18/2015(UTC)
Posts: 98
Man
United States

Thanks: 8 times
Was thanked: 14 time(s) in 12 post(s)
Hi Jory,

You have the bracket backwards (it's a little confusing, I understand). The $XDAYSAGO variable looks at the literal time of 180 days ago to do the comparison, so if you set it to GuestInfoUpdateTime < 180 days ago, the site gets the date of 180 days ago and shows you everything that's less than that (e.g. 0-179 days). You should get what you're looking for by using this:

GuestConnectedCount = 0 AND LastConnectedEventTime > $180DAYSAGO

The problem I see with that filter is that if you run database maintenance for less than 180 days, there will never be a LastConnectedEventTime that's 180+ days old. GuestInfoUpdateTime would be an acceptable substitute since that one doesn't get wiped out with DB maintenance:

GuestInfoUpdateTime > $180DAYSAGO
ConnectWise Control (ScreenConnect) Support Team
jorylane  
#9 Posted : Monday, August 14, 2017 7:05:58 PM(UTC)
jorylane


Rank: Newbie

Medals: ScreenConnect Advisor: Focus Group Member

Joined: 3/13/2014(UTC)
Posts: 8
Canada
Location: Toronto

Thanks: 1 times
Hmm, I did try GuestInfoUpdateTime > $180DAYSAGO, however I don't get the expected results with the bracket facing that way (I get the reverse).
However, if I switch it to GuestInfoUpdateTime < $180DAYSAGO, I get the desired results.
Users browsing this topic
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.