Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
vendors:cisco:uc:icm:sql:inventory [2020/01/14 12:54]
gerardorourke [Hostname and Host Port]
vendors:cisco:uc:icm:sql:inventory [2020/01/29 14:54] (current)
gerardorourke [Host Services Status]
Line 142: Line 142:
 FROM Machine_Host H FROM Machine_Host H
 JOIN Machine_Address A ON H.MachineHostID = A.MachineHostID JOIN Machine_Address A ON H.MachineHostID = A.MachineHostID
 +</code>
 +
 +===== Host Services Status =====
 +
 +<code sql>
 +/****** Script for SelectTopNRows command from SSMS  ******/
 +SELECT [MachineServiceID]
 +   ,[M].[MachineName]
 +      ,[S].[MachineHostID]
 +      ,[S].[MachineAddressID]
 +      ,[S].[ServiceType]
 +      ,[S].[ServicePort]
 +      ,[S].[ServiceUri]
 +      ,[S].[Pairing]
 +      ,[S].[UserName]
 +      ,[S].[Password]
 +      ,[S].[EnablePassword]
 +      ,[S].[AutoGenerated]
 +      ,[S].[Description]
 +      ,[S].[MachineConnectionProfileID]
 +      ,[S].[OutOfSyncTimestamp]
 +  FROM [ucce_awdb].[dbo].[Machine_Service] S
 +  LEFT JOIN Machine_Host M ON [M].MachineHostID = [S].MachineHostID
 +  
 +  ORDER BY Pairing DESC
 </code> </code>