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

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

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

I use 3200 MB to group the systems into x86 and x64 categories.

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