Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| vendors:cisco:uc:icm:sql:inventory [2020/01/29 08:27] – [Log File collection] gerardorourke | vendors:cisco:uc:icm:sql:inventory [2020/01/29 14:54] (current) – [Host Services Status] gerardorourke | ||
|---|---|---|---|
| Line 165: | Line 165: | ||
| FROM [ucce_awdb].[dbo].[Machine_Service] S | FROM [ucce_awdb].[dbo].[Machine_Service] S | ||
| LEFT JOIN Machine_Host M ON [M].MachineHostID = [S].MachineHostID | LEFT JOIN Machine_Host M ON [M].MachineHostID = [S].MachineHostID | ||
| + | | ||
| + | ORDER BY Pairing DESC | ||
| </ | </ | ||