Differences

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

--- vendors:cisco:uc:icm:sql:inventory [2018/05/17 19:56] – ↷ Page moved from code:java:vendors:cisco:uc:icm:sql:inventory to vendors:cisco:uc:icm:sql:inventory gerardorourke
+++ vendors:cisco:uc:icm:sql:inventory [2020/01/29 14:54] (current) – [Host Services Status] gerardorourke
@@ Line 11: / Line 11: @@
 </code>
-====All known system data====
+=====All known system data=====
 <code>
 SELECT H.MachineHostID, H.MachineName
@@ Line 91: / Line 91: @@
 </code>
-====Hostname and Host Port====
+=====Hostname and Host Port=====
 <code>
 SELECT H.MachineHostID, H.MachineName
@@ 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>