Hello,
Last week i did an upgrade to version 2.2.10
We used to had a daily report through a db query that we check for systems that are in maintenance mode.
the query is this one:
After the upgrade the query is not working. I see some changes in the names but i cannot find a value for the maint_mode.
Have you move it to different table?
thanks
Last week i did an upgrade to version 2.2.10
We used to had a daily report through a db query that we check for systems that are in maintenance mode.
the query is this one:
Code Select
USE netxms_db
DECLARE @OBJECT_ID INT, @NAME VARCHAR(63), @ITEM_ID INT, @DESCRIPTION VARCHAR(255)
SET @OBJECT_ID = 0
SET @ITEM_ID = 0
DECLARE @UNMANAGED_SYSTEMS TABLE(
System VARCHAR(63)
)
WHILE (1 = 1)
BEGIN
SELECT TOP 1 @OBJECT_ID = object_id
,@NAME = name
FROM netXMS.object_properties
WHERE object_id > @OBJECT_ID AND maint_mode=1
ORDER BY object_id
/* Exit loop if no more entries */
IF @@ROWCOUNT = 0 BREAK;
INSERT INTO @UNMANAGED_SYSTEMS SELECT @NAME AS System FROM [netxms_db].[netxms].[items] WHERE node_id = @OBJECT_ID
END
SELECT * FROM @UNMANAGED_SYSTEMS GROUP BY System ORDER BY System ASC
After the upgrade the query is not working. I see some changes in the names but i cannot find a value for the maint_mode.
Have you move it to different table?
thanks