This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

NCM EOS/EOL Dates Query - 7.2

Hi, Upgraded to 7.2

Is there a way around having to go into every device and select the corrcet model and EOS/EOL date from the suggestions?

I already have EOS, EOL dates against most node IDs in NCM from manual work - and to now have to go back through and select 1000 of them manually is a bit much...any help?

If the answer to the above is "it is a manual process only" then i will need to be able to import the attached into the nodes table, linking the appropriate fields in the EOS tables to keep consistancy. as the moment I am about a year behind where i was with my own EOL reporting.

Edited: This needs to be based on 'Inventory data' as per my reports, NCM needs to be able to support switch stacks (3750x) and VSS (Virtual Switches) which are represented as one node in NPM, and for many other purposes in NCM, but for EOL/EOS and inventory based functions like this it will maybe need to EOL/EOS data residing in the Physical Inventory table instead? so that line cards and all other modules could be reported on?

CSV of current dates attached. (Cisco_EOL_Dates_PerNode_NCM.txt)

Copy of current report and colour formatting also attached (summary version only so I dont have to redact information). I will as soon as i have all the correct data in NCM Nodes re-create the sql report and share to the community. (Audit Count by Model ALL.pdf). All data is taken from NCM, formatting is as below;

Fill:

=IIF(Fields!EoL.Value < Today(), "Red",

IIF(Fields!EoL.Value < dateadd(dateinterval.Year, 2, Today()), "Orange", IIF(Fields!EoL.Value < dateadd(dateinterval.Year, 15, Today()), "GreenYellow", "White")))

Font:

=IIF(Fields!EoL.Value < Today(), "White","Black")

Lastly I have some issues, which i will log here first then if required log a feature/bug request.

1. Device in Sale/Support

Would like it to show a 'green tick' next to devices that have not had an EOS or EOL raised against them.

"n\a" or similar in date fields. At the moment it looks like they have just not found a matching item,

and shows as 'no suggested dates' rather than 'no notice is applicable etc

2. Manual Date Boxes

Does NOT let you type in a date directly, have to scroll through months and months to get to the correct year!! not user friendly.

3. 'Best Match' Option

It may be better if NCM could match the PartNo not machinetype it seems to use (very good on Cisco EOL codes) and make a best match, rather

than manually having to go through each device and choose the one that matches.

Can SW share the matching code it uses? see if it can be tweaked by us SW users..

attachments.zip

Top Replies

  • Where is update inventory? I’ve looked all across the EOL screen and only see the refresh suggested dates

  • It's NCM (Configs tab) -> Reports -> Update Inventory.

    You can also do it through a job.

    Jiri

  • That is being done every night and has been active since the 7.3 update. SO my original statement stands. You’re giving me 100% useless data on the class of device I mentioned

  • Hi Jeff Norton,

    I believe there's a problem in your NCM installation. If you have 400 37XX devices, you should definitely have some "green" EOL data. See the screenshots from my NCM:

    EOL-Part-Number.png

    EOL-Part-Number2.png

    I suggest that you open a support ticket so that we could find the root cause of the problem.

    Regards,

    Jiri

  • There’s nothing wrong with the install. Your people have been over it on some other issues we had just after the 7.3 install.

  • Let me try and clarify this a bit. I have 540 37xx devices. Of that amount 400 are not assigned EOL dates. Of the 400 devices not assigned, 100% of those show dates that either are yellow or red. What I’m saying is that if it isn’t a sure fit or even a close fit then don’t show me suggested dates because those dates are 100 % not applicable. As it stands right now I have to go through these things one at a time just to see that none of them are applicable. A better method would be to show me a little color icon at the upper level list that shows me the highest match suggested date category so I don’t waste my time. Or let me apply a filter that says unless it’s green don’t show it as suggested. I recognize that this Is not perfect, but it is definitely doable. Cisco’s Ciscoworks product has had this capability for years and all the data they used are published on their web pages

    From: Norton, Jeff

    Sent: Tuesday, July 29, 2014 6:55 AM

    To: 'jive-504792431-51a-2-58mn@solarwinds6.hosted.jivesoftware.com'

    Subject: RE: - NCM EOS/EOL Dates Query - 7.2

    There’s nothing wrong with the install. Your people have been over it on some other issues we had just after the 7.3 install.

  • Let me be even more specific. I have a Cisco WS-C3750G-24TS-E1U. It has an EOL document on the Cisco web site, www.cisco.com/.../eol_c51-696372.html. The dates listed in the Cisco document are not mentioned at all in the Suggested dates for that part number in the Orion NCM database. It took me less than 1 min to find the Cisco document. All I did was google “WS-C3750G-24TS-E1U EOL”. Now I’m no rocket scientist only a humble network engineer, so if I can do that then the developers at Solarwinds should certainly be able to do that.

    From: Norton, Jeff

    Sent: Tuesday, July 29, 2014 7:08 AM

    To: 'jive-504792431-51a-2-58mn@solarwinds6.hosted.jivesoftware.com'

    Subject: RE: - NCM EOS/EOL Dates Query - 7.2

    Let me try and clarify this a bit. I have 540 37xx devices. Of that amount 400 are not assigned EOL dates. Of the 400 devices not assigned, 100% of those show dates that either are yellow or red. What I’m saying is that if it isn’t a sure fit or even a close fit then don’t show me suggested dates because those dates are 100 % not applicable. As it stands right now I have to go through these things one at a time just to see that none of them are applicable. A better method would be to show me a little color icon at the upper level list that shows me the highest match suggested date category so I don’t waste my time. Or let me apply a filter that says unless it’s green don’t show it as suggested. I recognize that this Is not perfect, but it is definitely doable. Cisco’s Ciscoworks product has had this capability for years and all the data they used are published on their web pages

    From: Norton, Jeff

    Sent: Tuesday, July 29, 2014 6:55 AM

    To: 'jive-504792431-51a-2-58mn@solarwinds6.hosted.jivesoftware.com'

    Subject: RE: - NCM EOS/EOL Dates Query - 7.2

    There’s nothing wrong with the install. Your people have been over it on some other issues we had just after the 7.3 install.

  • There’s nothing wrong with the install. Your people have been over it on some other issues we had just after the 7.3 install.

    Let me try and clarify this a bit. I have 540 37xx devices. Of that amount 400 are not assigned EOL dates. Of the 400 devices not assigned, 100% of those show dates that either are yellow or red. What I’m saying is that if it isn’t a sure fit or even a close fit then don’t show me suggested dates because those dates are 100 % not applicable. As it stands right now I have to go through these things one at a time just to see that none of them are applicable. A better method would be to show me a little color icon at the upper level list that shows me the highest match suggested date category so I don’t waste my time. Or let me apply a filter that says unless it’s green don’t show it as suggested. I recognize that this Is not perfect, but it is definitely doable. Cisco’s Ciscoworks product has had this capability for years and all the data they used are published on their web pages.

    Let me be even more specific. I have a Cisco WS-C3750G-24TS-E1U. It has an EOL document on the Cisco web site, www.cisco.com/.../eol_c51-696372.html. The dates listed in the Cisco document are not mentioned at all in the Suggested dates for that part number in the Orion NCM database. It took me less than 1 min to find the Cisco document. All I did was google “WS-C3750G-24TS-E1U EOL”. Now I’m no rocket scientist only a humble network engineer, so if I can do that then the developers at Solarwinds should certainly be able to do that.

    And while we’re on this subject, why is it that if I find the correct dates and assign them, that assignment is not now listed in my local database so that I can use it again? As it stands now I have to re-enter those dates over and over again for every applicable device. That’s just WRONG on so many levels

  • jeffnorton,

    You can validate yourself that correct EoL dates for Cisco WS-C3750G-24TS-E1U are there in the database.

    The EoL datafile can be found on your NCM server in C:\ProgramData\Solarwinds\Cirrus\Eos. Open it in an appropriate tool (e.g. SQL Compact Query Analyzer) and run the following query:

    select * from Eos where Id in (select EosId from PartNumbers where PartNumber='WS-C3750G-24TS-E1U')

    You can see that we have the right data for the above part number:

    PartNumberQuery.PNG

    Regards,

    Jiri

  • That may be but it did not pop up as a suggested data for the part number.

    This is tiring. I’m telling you there is a problem with how the database is interacting with the part numbers and you’re just arguing there isn’t. The fact is the EOL tool is NOT reliable and I have shared with you the proof. I just went through 540 devices I have in the Cisco 37xx product line manually yesterday and the correct EOL data popped up maybe 5 times. Now you can either look into it or you can keep arguing. Either way, I and a lot of others that have complained will not rely on the application. While I applaud Solarwinds attempt to provide life cycle management, the implementation, to put it bluntly is crap.