The Scenario
The compliance audit lands in your inbox on a Friday afternoon. The auditor needs a list of every Linux server in the ServiceNow CMDB with operational state "operational" — hostname, IP address, OS version, environment, and assigned support group — by end of business Monday. You are the IT compliance officer. The CMDB has the data. Getting it into a clean Google Sheet without spending your weekend in ServiceNow is the problem you are solving right now.
The bad version:
- Open ServiceNow CMDB, navigate to the Linux Server CI class, filter by operational state, export to CSV.
- Open the CSV, discover it has 58 columns, delete the 50 you do not need.
- Find that the support group column is a sys_id reference, not a human-readable name, and run a separate lookup to translate each one.
The data exists. It is in ServiceNow. The audit report is not the problem — building the query, wrangling the export, and cleaning the output is.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It queries the ServiceNow CMDB with your filter conditions and writes exactly the columns you ask for — no extra fields, no sys_id translation required on your end.
Get all Linux server CIs from ServiceNow CMDB with operational state operational and write the hostname, IP address, OS version, and environment into columns A through D
What You Get
- One row per operational Linux server CI in the CMDB
- Columns A through D populated with hostname, IP address, OS version, and environment
- Support group names resolved to readable labels, not sys_ids
- The full result set returned regardless of row count — no export page limit
What If the Data Is Not Quite Ready
You need the assigned support group name in column E for the audit report
The auditor wants to know who is responsible for each server, not just the server's specs.
Get all Linux server CIs from ServiceNow CMDB with operational state operational and write the hostname, IP address, OS version, environment, and assigned support group name into columns A through E
Some CIs have a blank OS version because they were created before that field was required
The audit expects every row to have an OS version. Blank rows need to be flagged.
Pull all Linux server CIs from ServiceNow CMDB with operational state operational, write hostname, IP, OS version, environment, and support group into columns A through E, and flag any row where OS version is blank with "MISSING" in column F for manual follow-up
You need to filter to a specific environment — production only
The audit scope is production assets only, not staging or development.
Get all Linux server CIs from ServiceNow CMDB with operational state operational and environment set to Production, and write hostname, IP address, OS version, and assigned support group into columns A through D
Full kill chain: pull operational production servers, flag missing fields, add last-reviewed date, sort for the auditor
Pull all Linux server CIs from the ServiceNow CMDB with operational state operational and environment Production, flag any with a blank OS version or support group as "INCOMPLETE" in column F, write hostname, IP, OS version, environment, support group, and the CI created date into columns A through F, and sort by hostname ascending so the auditor can scan alphabetically
The audit deliverable is done before the weekend starts.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your CMDB operational Linux server inventory straight from ServiceNow. For loading new CI records into the CMDB, see the bulk-populate-cmdb spoke or return to the ServiceNow hub.