mnsh_majumder ✭✭✭✭✭

in new version we have found new issue , like in IPAM at our present version 2024.2 if you search any IP at global search button then it will give you the result but in new 2025.2 you need to select the subnet to which that IP belongs to then result will be given. there are more few bugs associated with the new version

we configured Report Scheduler by assigning the webpage link related to high availability Server & Pool. This was working fine until 2025.2 started creating problem. Now it shows "NO DATA" for any webpage aligned in report scheduler.

another Bug related to high availability. Even though the new GUI is good but once you create the pool, tool doesn't seem to save the details about virtual hostname / VIP and also auto disable the preferred active server. I tried multiple times but no luck. the only solution is to disable the HA for all the pools created

3rd bug detected, earlier in report schedule we were getting the report correctly for High availability using "assign Webpage" option but now in 2025.2 the report for those webpage related to "My Deployment" > Servers & Pools shows as no data.

Hi @"marcrobinson" does it work with 1 chart or 2 chart max ?

as other users have already suggested solutions please also check whether global scan/subnet scan/neighbor scan has been disabled or not. then it won't be able to display the data for each ips if its being used somewhere.

Yes its a known bug from 12.5 version which vendor said it will be fixed in the future release. please check the logs if it's really like maintenance never started for last 30 days. for me it shows but when i checked the logs the error was clear. Maintenace do run everyday at the scheduled time but it fails to clear some…

And also i've created one more KPI incase if DB maintenance didn't ran for more than 48 hours. below is the query which works for me TRIGGER CONDITION join [dbo].[Events] as E on Engines.engineid=E.engineid where E.message='Starting Nightly Maintenance' group by Engines.ServerName, Engines.EngineID,E.eventtime,E.Message…

i've created a batch file using below URL code which will start the DB maintenance if it finds any maintenance failure event. Have added "EXECUTE AN EXTERNAL PROGRAM" under trigger action to acheive this. support.solarwinds.com/.../Run-database-maintenance-as-a-scheduled-task

Have modified a bit to give the latest maintenance failed incase if you have triggered multiple times. please use this code. For trigger & reset condition, you just have to use the query starting from join condition with below modification respectively. For reset please use below query inplace of yellow highlighted…

not sure if this will help now i've created a KPI that triggers alert if DB maintenance has failed last night using sql query & it does work for me. i'm using 2023.1 version at present.

<> is not part of sql query. It just showed up because of copy paste

Vendor resolved it. had to delete some APP tables as we used SAM many years back which left some residue tables. below is the code which vendor used to delete. /* Warning: This script removes ALL APM (SAM) structures and data from the database! 'FN','IF'..scalar valued functions 'TF'..table valued functions 'P'..procedure…

HI @"Frejus_MA"its quite normal for Orion main poller DB having that size as for my environment its around 190+GB. yes you can discuss with your customer & reduce the retention period, delete unwanted device/interface/volume etc. check if any unwanted syslog/traps are being sent as sometimes even NW team stays in the dark…

More ideas are there but still working on it to add more options

Below is the query for the node caption, you can add minute as per zone time as the time recorded in the table was in UTC. Below query is as per IST. SELECT eventtime, dateadd(minute,330,eventtime) as Deletion_date_IST ,networknode,message FROM [dbo].[Events] Where eventtype='8' and eventtime >= DATEADD (day, -30,…

did you got the solution for this?

did you checked whether you are able to access console using the same username & password

Hello, Not sure but have you tried to reinstall that service once again & run config wizard. 2. reboot the server after the previous steps. 3. Check telnet & ping connectivity with your DB host. If the ping drops then it might due to DB connectivity If not & still the issue persists then better check with vendor

Hello..Even if you manage to set the status as unplugged instead of down do you wonder what will happen during next snmp poll. obviously SW will detect the status as down instead of unplugged & may be it will reset to down status again. Just a hypothetical thought.

I would recommend for login process to access any SW dashboard instead of bypassing any security policy

Have been working on this part. I have set the trigger condition as below & modified the sql condition for email as below so that I'll receive alert if audit is not present for last 30 min's (including evaluation time as 15 min) SELECT case when count (timeloggedutc)>0 then 'Audit is present for last 30 minutes' else…

this query is giving me more better result as per requirement. INNER JOIN [dbo].[NCM_nodeproperties] AS NP ON Nodes.Nodeid=NP.coreNodeID --INNER JOIN [dbo].[NCM_ConfigArchive] AS NCA ON NP.NodeID=NCA.NODEID WHERE Np.lasttransferdate<DATEADD(DAY,-10,GETDATE()) AND NP.LASTTRANSFERMESSAGE NOT LIKE '%Complete%' and…

have modified the query(based on sql) to alert me whose backup last transfer message in not complete. SELECT Nodes.CAPTION,NODES.VENDOR,NP.LASTTRANSFERMESSAGE,NCA.AttemptedDownloadTime,np.loginstatus fROM [DBO].[Nodes] AS Nodes INNER JOIN [dbo].[NCM_nodeproperties] AS NP ON Nodes.Nodeid=NP.coreNodeID INNER JOIN…

What issue are you facing. Have you tried my query

Made some changes to give the report for list of palo which doesn't have CLI enabled SELECT caption,ip_address,vendor FROM [dbo].[NodesData] where vendor like'%palo%' and ip_address not in ( select n.IP_address from [dbo].[nodes] n join [dbo].[NodeSettings] ns on n.NodeID=ns.NodeID where ns.SettingName like…

Looks like even this query is also not working

I did setup one small query for Health check report as below but the challenge is we can't modify the select statement while creating the alert based on SQL SELECT case when count (timeloggedutc)>0 then 'Audit is present for last 12 hours' else 'Audit is not present for last 12 hours' end as Audit_Log_Record_Status FROM…

created an additional query for audit log report if any resource was deleted SELECT accountid,timeloggedutc,auditeventmessage, DATEDIFF (day, timeloggedutc, (select DATEADD(hour, -6, getutcdate()))) AS [DAYS], DATEDIFF (month, timeloggedutc, (select DATEADD(hour, -6, getutcdate()))) AS [MONTH] FROM [AuditingEvents] where…