mezdem

its been voted on for two years, not looking promising, this is essential feature for managing maintenance windows.

is there any update on this thread? we need to run a dev environment to test updates and new modules and functions

did this go anywhere? is it available

did this get deployed? is there anyway of customising this at present.

yes +1 similar to the 'base config' comment in my prev post. http://thwack.solarwinds.com/message/212027#212027

i have this resource working well now in NPM, no links through to port history - so maybe still one for SW devlopment team. Re: Re: Unused Ports -> Contextual web resource

any update on whether this was implemented yet? crucial for our implementation

I am also struggling with some items on LWAPs, in orion the APs table, only a handful are showing the model name and ap type. Other APs on the same controller have a null model and type. I have 16 over 4 controllers that have a value and all the other 000's are null. Can you let me know if this is a bug? or what MIB orion…

and a slight change and this now works.. there is a table that records response times, this then reports on availabilty- so the last part of the query excludes all records that have been available 100 in last 3 days.. its getting close - see what solarwinds come back with! SELECT TOP (100) PERCENT dbo.AlertLog.ObjectName,…

I have checked this morning, and for me the original script works fine, as the node that went down early this morning is not showing in the report - which is correct. I am on version 10... are you the same?

glad it works! I took the seconds off also!! re the custom poller, i have never queried that field always use the historical data. But this works on mine... might need tweaking for pollerID etc select *, convert(datetime,CustomPollerStatus.Status), DATEADD(year,-3,getdate()) from dbo.CustomPollerStatus WHERE…

Yes i think its possible - I think someone at SW should comment here?? Network Sonar - is a network discovery option within Orion. You can schedule discovery by IP range, list of IPs or by Subnet (as i do). On this schedule it can pick up all devices that repond on each subnet, personally we only keep network related nodes…

I think you will have to run a sql profiler trace. If you create a new profile trace from ssms, select (as below) - filter by dbname also. - Locks --> Deadlock Graph --> Lock escalation * Post the results Then add after you do/dont get any results add - TSQL --> exec prepared sql -->sql: batch starting -->sql: batch…

hi everyone, got the coloured rows working a treat for me, but for other users i get Report resource failed to properly initialise is this still a bug, as i have just upgraded to the latest version? How can i just add the web report i have created to the page instead of using this custom table resource?

excellent.. fingers crossed! *One for SW to look into I think - I only have the one polling engine so its not occuring on mine

i cannot test as i have no data like yours! try this.. 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.NodeID…

Orion 10.1 does hold switch port mapping data it uses for the topology generation. I am not sure what resources I can add it to yet - as there is no option for mac address search in this View (dbo.OrionSwitchPortMapping) but when I need to find something I start here with a sql query! I am writng some reports from this -…

basically this is a lot simpler, convert the time difference between now and last poll of the node, converted into seconds. then you can easily convert the seconds into downtime - or uptime as i use for our monthly and quarterley availability stats.. Does this work rgward?

Hmmmm i think that was the other part of the code i took out - i was trying to get it to only look for ones that were over 3 days.. I will need a 'NOT IN' clause again.. I will have a look... again its difficult if we have different data to work with!

We are updating a lot of interface descriptions as part of a full network tidy.. I have changed some today and they do not update in v10 sp1... Is this correct? Monitoring 6,000 interfaces with no auto-update?

i think this works! run them next to each other and see if ok for u! working on my nexus 10 tablet so copy and paste is fun! SELECT statusled, nodeid, caption, status, CONVERT(varchar(6), convert(varchar(10), DATEDIFF(ss,lastsystemuptimepollutc, GETUTCDATE())) /86400)+ ' Days ' + RIGHT('0' + CONVERT(varchar(6),…

thanks for this, sql i'm am ok with, working with resources - not so much! I have tried and failed miserably I have created a view for the events, all the 'where' and 'order bys' are performed in the view for ease of change. SELECT TOP 25 [NodeID] ,[Event_Time] ,[Time] ,[Vendor_Icon] ,[NodeName] ,[EventTypeIcon]…

no worries glad to help, 10 years of being a DBA and Developer and newly a cisco network bod, I still hanker to get involved back in the sql code !! (sad i know).. It is also helping Me build a database structure in my mind - only had it installed a month!

can you run the code in SSMS - and run the analyze query / or run actual query execution plan from the 'query' menu and post the results.. -- Run the query with each engine/server name in turn , with the values returned from the engine table.Select servername from dbo. engines -- Set the value for @servername and run see…

hi yep sorry i thought it was a little out, i have since found a better way of doing this. i have this in the ncm content sharing zone under `availability reports`. i will get the sql for u as soon as i can.

hmm with intrefaces, it may be easier to link back to the triggered alert/event from Orion, you can see the info you require from the Interfaces table... but i have not had to use these data before so you would need to check to see how accurate it is. There is a lastchange field..now on the coupld i checked this worked…

You will need a Device CAL and you will definatley need a user CAL for everyone you wish to access the web console or report. This is called a Server/CAL license. For instance if you have 10 staff that access Orion web console, and have 2 staff in Service Desk who access the reports. You will need 12 User CALS. We use 'Per…

Thanks

any joy with this, we are in the same boat now.

Yes we are going to upgrade in the next 6 months.. how can i prove/monitor just this buffer for this port in orion?