Page History
Below outlines the most commonly used Microsoft SQL Commands utilized with most Perspectium integrations:
JOIN
A Join statement is used to combine data or rows from two or more tables based on a common field between them. The table below outlines the join relationship between two tables and a brief explanation of the use cases.
Query | Use Cases | |||||
---|---|---|---|---|---|---|
| View the users assigned to configuration items | |||||
| Incidents with their SLA | |||||
| View incidents with location | |||||
| View incidents with users by caller | |||||
| For customers that prefer to work with display value fields instead of id. This will join the table based on display name | |||||
| Detecting incidents that have CIs attached | |||||
| View SLAs by parent task table grouping by display number |