Differences

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

--- vendors:cisco:uc:icm:sql:inventory [2020/01/14 12:54] – [Hostname and Host Port] gerardorourke
+++ vendors:cisco:uc:icm:sql:inventory [2020/01/29 14:54] (current) – [Host Services Status] gerardorourke
@@ Line 142: / Line 142: @@
 FROM Machine_Host H
 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>