mezdem

any update on this issue? as i have the same problem and need users to see reports/custom table resources i have created using SQL and html tags to colour rows.

Yep thanks yes i have been off ill too! checked today as syslog forwarding is working like a charm - thank you very much

providing your sql servers local time is set to GMT-5 then your Getdate() will be correct and then just diff this from the UTC date.# --change all the 'LastSystemUpTimePollUtc' in code to 'DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), Nodes.LastSystemUpTimePollUtc)' select NodeID,IP_Address,Caption, Status, StatusLED,…

arh brill footerest! glad i could help - yeah never realised re the Getdate() - good one to remember! rjager - i am not sure what is showing incorrect? i missed your post? I have been working on some other reports for monthly/quarterly availability, and so I may have a better solution for view the time down counter - as i…

I also have a query with the sonar, as we are about to start a new naming scheme accross all our 950 cisco devices to meet various audit requirements. I need to know whether I should let the sonar handle it...will it see it as a new device? different host name- possibly different ip depending on how/which way it finds it..…

Yes thanks the sql part is fine as I am a DBA...its just i would of thought this would of been easily doable within the report writer - for those who dont have direct access to the sql database and query analyser..

Hi, Thanks. I have provided both Util % and Bps but management only ever want to see the Actual Bandwidth bps/kbps/mbps - which is why i has to create reports from scratch! If this could be raised, as It would be ideal if you could customise the existing charts so that you could pick and choose between the series diaplayed…

Thanks for this works great! All users are now logging in using NT Authentication. A little overhead with the setup up of each user 'Domain\username' and 'password' in the password field..but overall its works well and stops maintenance of passwords for orion totally. Would really be beneficial to be aboe to add AD Group…

I wont be able to provide full configs, but partial/redacted ones.. I will log a case - Cheers Jiri

I have got this web resource working a treat now. Create a new report (old/new way) - mine is still via report writer - old habbits and all that. SQL for the query is: SELECT Nodes.Caption AS Caption, UDT_UnUsedPorts.PortID AS PortID, UDT_UnUsedPorts.Name AS Name, UDT_UnUsedPorts.PortDescription AS PortDescription,…

SELECT TOP (100) PERCENT dbo.AlertLog.ObjectName, dbo.AlertDefinitions.AlertName, convert(varchar(10),dbo.AlertLog.LogDateTime, 101)as AlertRaised, dbo.AlertLog.ObjectType, dbo.Nodes.IP_Address, dbo.Nodes.Caption, dbo.Nodes.Location, dbo.Nodes.Status, dbo.Nodes.NodeIDFROM dbo.ActionDefinitions INNER…

Excellent. Quick explanation is that basically if you had it in full recovery mode all transactions are stored in the log file. If you were not to backup up the transaction log as part of your db maintenance then a checkpoint is not created, this means that it can not truncate that part of the log file (commited trans) and…

Hope someone can help with this..I have got a little further this morning.. even though I get randomly a timeout or the message tghe OID is not supported - I have managed to get to the stage where it allows me to choose the label for each row returned in the table.. However, once completed The poller just never runs, it…

You can change these as you see fit. I have mirrored the stats you get from the graphing resource in NPM. The util In+Out is the MAX of the average bps for the day- Hope that makes sense - its an awkward one as your data will start to aggregate on a routine maintenance, so detailed becomes hourly which then becomes daily…

Hi, any more updates on this issue? I really need to be able to raise an alert in NPM and email when a port goes into ERR DISABLE ..I have looked at the custom poller and the syslog messages and neither seem to do what is required?

arh that may be why i used DES! sorry it was a while ago i set this up in Orion.

hmm not really had to convert this before personally... but maybe something along the lines of the below? SELECT DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), Nodes.LastSystemUpTimePollUtc)AS ColumnInLocalTime , .LastSystemUpTimePollUtc as LastSystemUpTimePollUtc FROM Nodes

of course if you let me know what you what to achieve I can provide scripts. I dont purge via SQL, I just flag as baseline if I want to keep them, then I run the NCM purge job. --select- select * from ConfigArchive where ConfigType = 'Running' -- or use 'Startup' AND DownloadTime < GETDATE()-30 -- i.e. i.e. downloaded…

well i've been forced to log a support ticket as no reponse on here from any SW represenative. Case#: 718901 Have also asked if the new RC release 3.02 fixes the issues and makes UDT usable again, or not.

Thanks, I have posted in relation to the actual cause.. ports open and account is fine, having a sql error to do with nolock parameter.. 2012-01-13 10:10:52,600 [6] ERROR SolarWinds.InformationService.Core.InformationService - Exception running query: SELECT N.NodeID, N.Caption, N.IPAddress FROM Orion.Nodes (nolock=true)…

Only just started using Orion.. have had one port on a switch that needed upgrading to gib from 100mb due to transmit discards. this is resolved, but a new issue has appeared on one or our cores... Our 6509 CatOS switch is now reporting 000's discards on Port 2/8 (module WS-X6408A-GBIC:3.0), its a 1gb link to our 2nd…

I think I had something similar the other week when sync wasnt working, i changed some IP addresses in NPM (50) and the two db's got out of sync. When you run the db sync it then copies the old nodes (old IP addresses) back into NPM, however the new CoreID in NCM is different to the NPM NodeID as it created new nodes. it…

bump - just found this problem ourselves. can SW mention to Cisco as i know you disucuss a lot of functionality with them?

This MIB is still not supported. I can 'get table' from any other snmpc system like snmpc, but orion does not return table data.... There are 27 variables in this sensorIntelliAmpTable - do I have to poll all 27 then combine them back together - or should this get table work for this OID? I have downloaded a new MIB today.

I have this added as a feature request, please vote

brilliant thanks acy! it is working - well not had duplicate for same host...just need to wait another 3 hours! Thank you, and yes I guess now i can see the similarities between the coding - I will have to attempt the next one on my own (maybe)

sorry the chart in the picture above is % utilization? not bps

bump this is exatley want we require also. The first comments back from engineers re UDT - was a question as to whether there was a resource that will show them quickly per switch which ports can be re-patched i.e. not been used in xx days (bepoke threshold dependant) so that we dont have to reset counters and check back…

no your doing it right - i have found the error in my code - will get back to you with it !

yep just checked i am not sure if i extracted all devices, machine types are in the pdf. Just checked sql, just the one unknown, and random 'cisco' as machine type! Cat 45068Catalyst 295024 SX6Catalyst 29602Catalyst 2970242Catalyst 297024 TS1Catalyst 356024 PS103Catalyst 356048 PS1Catalyst 3560X 2413Catalyst 3560X 24…