Database table names can be used in reports and other database queries.
The following table lists organization-level (ORG1) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.
|
Service Desk: User Console | |
|
Service Desk: User Console | |
The following table shows the System-level (KBSYS) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.
Database table names can be used in reports and other database queries.
The following table lists organization-level (ORG1) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.
|
Service Desk: User Console | |
|
Service Desk: User Console | |
The following table shows the System-level (KBSYS) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.
You can add steps to scripts in the Scripting component.
The following tables detail the steps that can be added to the task sections of scripts. Task sections are available on the Script Detail page when you add a task. See Adding and editing scripts.
The column headings V, OS, R, ORS, and ORF indicate whether a particular step is available in the corresponding task sections: Verify, On Success, Remediation, On Remediation Success, and On Remediation Failure.
For example, specify the path for HKEY_LOCAL_MACHINE for 32- and 64-bit Windows devices as follows:
|
Search for "%{name}" in "%{startingDirectory}" on "%{drives}" and "%{action}". |
||||||
|
Set the text in the message window named "%{name}" to "%{text}". |
||||||
|
Verify that the file "%{path}\%{file}" was modified since "%{expectedValue}". |
||||||
|
Search for "%{name}" in "%{startingDirectory}" on "%{drives}" and "%{action}". |
||||||
|
Verify that the file "%{path}\%{file}" was modified since "%{expectedValue}". |
||||||
The appliance supports variables for use in LDAP Labels and database queries.
Device or machine variables can be used in LDAP Labels and queries to automatically group devices by name, description, and other LDAP criteria. During LDAP Label processing, the appliance replaces all KBOX_ defined variables with their respective runtime values. The following table shows supported device or machine variables and their mapping to columns in the MACHINE database table and LDAP attributes.
User variables can be used in LDAP Labels and queries to automatically group users by domain, location, budget code, or other LDAP criteria. During LDAP Label processing, the appliance replaces all KBOX_ defined variables with their respective runtime values. The following table shows supported user variables and their mapping to columns in the USER database table and LDAP attributes.