ServiceNow pending exports (Internal)

Note

This query requires the SERVICENOW license option.

OctoSAM Internal Query

Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.

List all machines that have pending updates to ServiceNow since last export.

Fields

Name	Type	Visible	Description
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization	string	true	Name of the organization this entity is mapped to
Organization Description	string	false	Description for the organization this entity is mapped to
Machine ID	numeric	false	Internal ID that references the Machine entity (Foreign Key)
Machine	string	true	Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Machine Name	string	false	Machine name (computer name)
Alternate Name	string	false	Contains the computer name for systems that may have different host and computer names, such as macOS.
Fully Qualified Domain Name	string	false	Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Machine Description	string	false	Description attribute of the directory service or manually entered during offline scan
Alternate Description	string	false	Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
Domain Name	string	false	Windows NETBIOS Domain Name
Site	string	true	Name of the Active Directory Site that this machine belogs to
Location	string	false	Location attribute from Active Directory
Network Address	string	true	Network address, usually the IP number.
Network Mac Address	string	false	MAC address of the main interface (corresponds to NetworkNetworkAddress
Network Subnet Mask	string	false	Subnet mask if network address is an ip number
Network Network Address	string	false	Network address calculated from NetworkAddress and NetworkSubnetkMask fields
Network Network Name	string	false	Network name can be set from an external source. Not used by OctoSAM.
Network Network CIDR	string	false	Network in CIDR notation
Network Default Gateway	string	false	Network default gateway
Network DHCP	bool	false	True if DHCP is enabled on the main interface of the machine
Network DNS	string	false	Addresses of configured DNS servers
SID	string	false	Computer SID
Operating System	string	true	Operating System installed on this machine as reported by OctoSAM scanners
Operating System Publisher	string	false	Publisher of the OS.
Operating System Family	string	false	A short name to identify different operating system families
Operating System Server	bool	false	True if this OS is a server version
Operating System Version	string	false	Additional version information about the OS
Operating System Build	string	false	Build number of the OS
Operating System Install Date	date	false	Date/Time this OS instance was installed (as reported by WMI)
Operating System Language	string	false	Language of the operating system as reported by WMI in cleartext
Created	date	false	Time this object was created
Last Scan	date	true	Date/Time this entity got scanned last
Last Scan GUID	guid	false	Global Unique IDentifier of the last scan
First Scan	date	false	Date/Time of first scan of this machine
Last Found In Directory	date	false	Time the object was last found in the directory service
Deleted In Directory	bool	true	True, if directory check detects that the machine is no longer found in directory.
Deleted In Directory First Detected	date	false	Date/Time the delete flag was set
Directory Path	string	false	Path where the machine was found in the directory service. Usually an LDAP path.
Directory Container Path	string	false	Path to the container of this object. Provided for grouping or export to other applications.
Raw Manufacturer	string	false	Manufacturer of the machine as defined in WMI
Manufacturer ID	numeric	false	Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer	string	false	Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model	string	true	Model of the Machine as defined in WMI
Bios Serial Number	string	false	BIOS Serial Number as reported by WMI
Bios Smbios Uuid	guid	false	SMBIOS UUID of the machine
Bios Asset Tag	string	false	BIOS asset tag if supported
Bios Name	string	false	BIOS Name as reported by WMI
Bios Version	string	false	BIOS Version as reported by WMI
Bios Sm Bios Version	string	false	SMBIOS Version as reported by WMI
Processor	string	true	Processor Name as reported by WMI
Processor Speed	numeric	false	Max speed of the processor in MHz
Number Of Processors	numeric	false	Number of processors as reported by WMI
Number Of Cores	numeric	false	Number of cores as reported by WMI
Number Of Logical Processors	numeric	false	Number of logical processors as reported by WMI
Oracle Core Factor	object	false	Oracle Core Factor to use for Oracle pricing. Queries should alwas use this field.
Physical Memory	numeric	false	Amount of physical memory in the system as reported by WMI
Chassis Types	string	false	ChassisTypes as reported in WMI in cleartext
Directory When Created	date	false	WhenCreated attribute from Active Directory
Directory When Changed	date	false	WhenChanged attribute from Active Directory (updated on import and on housekeeping)
Directory User Account Control	numeric	false	UserAccountControl attribute from Active Directory (updated on import and on housekeeping)
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Most Frequent User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Most Frequent User	string	true	User that is most frequently using this machine
Most Frequent User Guid	guid	false	OctoSAM internal Guid of the user that is most frequently using this machine
Most Frequent User Organization ID	numeric	false
MFU Last Scan	date	false	Date/Time the most frequent user on this machine got last scanned
MFU Local Administrator	bool	false	True if the most frequent user on this machine had administrator rights at last scan
MFU Last Login Was Remote	bool	false	True if the most frequent user's last scanned login was from remote
Last User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Last User	string	false	User that last used this machine
Last User Guid	guid	false	OctoSAM internal guid of the user that last used this machine
LU Last Scan	date	false	Date/Time the last user on this machine got last scanned
LU Local Administrator	bool	false	True if the last user was localal administrator
LU Login Was Remote	bool	false	True if the last users login was from remote
Custom Field1	string	false	Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field2	string	false	Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field3	string	false	Available for custom data for this Machine, not used by OctoSAM Inventory
Custom Field4	string	false	Available for custom data for this Machine, not used by OctoSAM Inventory
Notes	string	false	Available for custom notes about this entity
Virtual Machine	bool	true	True if this is a virtual machine
Machine Guid	guid	true	OctoSAM internal Guid of this Machine entity
Service Now Sys ID	guid	true	ServiceNow: sys_id of the replicated object
Service Now Target Class	string	true	ServiceNow: target class of the replicated object
Service Now Last Export	date	true	Date/Time of last export to ServiceNow
Service Now Last Import	date	true	Date/time of last import from ServiceNow
Current Date Time	date	false	Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

• Machine

• VirtualMachine

Query information

Property	Value	Description
Query Guid	7e25118b-ce21-42a5-aea3-33619cc12238	The internal id of the query. Must be unique
SupportsDesktop	true	If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb	true	If true, the query can be started from the OctoSAM Web UI