SCCM | Intune | Windows 365 | Windows 11 Forums

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING SCCM Collection Query IP Based

dfulton

New Member
Messages
2
Reaction score
0
Points
1
Is there a way to create a sccm collection that detects when machines login outside of its assigned IP Range?
Our C-Suite folks want to know when users are logging in outside of the assigned IP range of just say 02.xx.xx.xx. to 02.xx.xx.xx

I've tried some queries but they wont return results
here's a sample one
SELECT *
FROM SMS_R_System
WHERE NOT (IPAddress BETWEEN '10.65.0.0' AND '10.65.255.255')
 
Is there a way to create a sccm collection that detects when machines login outside of its assigned IP Range?
Our C-Suite folks want to know when users are logging in outside of the assigned IP range of just say 02.xx.xx.xx. to 02.xx.xx.xx

I've tried some queries but they wont return results
here's a sample one
SELECT *
FROM SMS_R_System
WHERE NOT (IPAddress BETWEEN '10.65.0.0' AND '10.65.255.255')
ConfigMgr is not the right tool for this request. I also don't believe that wql has the between key word.

At the end of the day, what is the goal when you find these devices?
 
ConfigMgr is not the right tool for this request. I also don't believe that wql has the between key word.

At the end of the day, what is the goal when you find these devices?
Thanks for responding to my inquiry.
The goal is to discover which workstations on a daily basis that are not logging into the workplace outside of the xx.xx.x.x -xx.xx.xx.x ip range which is our HQ site range.

Is there a collection query that can be made to report such data? If so can you share it with me?

If not, any suggestions on how to get this accomplished?

Thanks Again
 
Thanks for responding to my inquiry.
The goal is to discover which workstations on a daily basis that are not logging into the workplace outside of the xx.xx.x.x -xx.xx.xx.x ip range which is our HQ site range.

Is there a collection query that can be made to report such data? If so can you share it with me?

If not, any suggestions on how to get this accomplished?

Thanks Again
ConfigMgr is not the right tool for this request.

You should look at some of the Enter ID tools for this. I forget which one of them will do it but they can even block login from out of your network, city, country, etc.
 

Forum statistics

Threads
6,783
Messages
26,393
Members
16,771
Latest member
tkolek
Back
Top