Query – Advanced with Ivanti EPM

Query Advanced Ivanti – Regex rules: device names (3 chars+L, M/N), IP with 0 in 3rd field. SQL queries: recent inventory, RAM >3200 MB

With Regex

• Example: DeviceName starting with 3 letters followed by the letter L.

• Example: DeviceName starting with 3 characters followed by the letter L.

• Example: DeviceName starting with M or N.

• Example: IP Address with 0 in the third field.

Query Workstations with Recent Inventory Dates

Query Advanced Ivanti – To retrieve workstations with an inventory date less than a specified number of days, execute the following SQL query:

"Computer"."Last Hardware Scan Date" > GetDate() - x

Query Advanced Ivanti – Ref :

• How to Query for Devices Updated by Inventory Since X
• About Custom Database Queries: How they work, guidelines on creating them, and examples of them in action

Query based on RAM

Query Advanced Ivanti – I use 3200 MB to group the systems into x86 and x64 categories.

Query Advanced Ivanti – I also display the memory capacity used by each SLOT in the columns to facilitate RAM upgrades.