Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Create Report Summary for Port status Admin-Up Down Inactive Last used etc

NPM NCM UDT IPAM NTA

Would someone please provide some assistance please.....

I seem to be going round in circles with creating a summary report for providing a weekly / monthly report with not too heavy on the layout but enough information ports.

I am new to SW and I have been tasked to produce a report for all sites Approximately 600 Cisco nodes.

I have no knowledge of SQL/SWSQL

The task is to provide a report that shows -

Device site

Device name

Toal ports

Used ports

Available ports

Operationaly status

Last Active

I have found the following code and applied it and it looks good but the code is not pulling in any data. To keep things simple I only discovered 1 site for its ports, but nothing is showing in the table.

i have modified the below code to include some more columns and info, but still no data. i will add the modified code when i logged in.

What do I need to do,to make this happen?

SELECT NodeID, Caption,

COUNT (*) AS "Total Ports", SUM (IsUp) AS "Used Ports", SUM (IsDown) AS "Available Ports"

FROM (

SELECT ND.Caption, ND.NodeID,

CASE WHEN OperStatus = 'Up' THEN 1 ELSE 0 END AS IsUp,

CASE WHEN OperStatus = 'Down' THEN 1 ELSE 0 END AS IsDown

FROM NCM_Interfaces NCMI INNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID)

INNER JOIN NodesData ND ON (NCMNP.CoreNodeID = ND.NodeID)

WHERE (InterfaceTypeDescription like '%ethernet%')

) T1

GROUP BY NodeID, Caption

ORDER BY Caption DESC

Both code and image is from Port count report

if anyone is able to proide some advice it would be appreciated.

many thanks in advance

Message was edited by: Phillsb Reference to SQL Code used.

Find more posts tagged with

Accepted answers

All comments

FormerMember

Hi wluther

as mentioned.

below is the code that i would like to use but it is not pulling in the data.

SELECT T1.NodeID, T1.Caption, n.n_site, n.Vendor, n.Description,

COUNT (*) AS "Total Ports", SUM (IsUp) AS "Used Ports", SUM (IsDown) AS "Available Ports",

CAST (ROUND ((1.0 * SUM (IsDown)/COUNT (*)) *100, 0) as float) AS "% Available"

FROM (

SELECT ND.Caption, ND.NodeID,

CASE WHEN OperStatus = 'Up' THEN 1 ELSE 0 END AS IsUp,

CASE WHEN OperStatus = 'Down' THEN 1 ELSE 0 END AS IsDown

FROM NCM_Interfaces NCMI INNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID)

INNER JOIN NodesData ND ON (NCMNP.CoreNodeID = ND.NodeID)

WHERE (InterfaceTypeName like '%ethernet%')

) T1

JOIN Nodes n ON n.NodeID = T1.NodeID

WHERE

n_site = 'WM%'

GROUP BY T1.NodeID, T1.Caption, n_site, n.Vendor, n.Description

ORDER BY "Available Ports" DESC

it would also be a nice to have where it selects all n_sites but be able to use a drop down menu, so either 1 or 2 sites could come up with the table then export?

Thanks

wluther

phillsb

Are you using "n_site" as a custom property, or does it represent something else?

On the presumption "n_site" is a custom property, and you are wanting to filter for "n_site" starts with "WM", then you will need the following:

Joining the "NodesCustomProperties" table to the query:

JOIN NodesCustomProperties NCP ON T1.NodeID=NCP.NodeID

Filtering by the "n_site" values contained within the "NodesCustomProperties" table:

WHERE

NCP.n_site LIKE 'WM%'

Adding the "n_site" column to the SELECT statement, making the values visible in the returned results:

SELECT

NCP.n_site

Adding the "n_site" custom property to the GROUP BY statement:

GROUP BY

NCP.n_site

The query below is actually the same as the one you previously provided. I simply spaced it out a bit more to make it easier to see what should go where.

Also, since I do not have a custom property named "n_site" in my environment, I used "area" instead, and the query seemed to work properly for my results.

SELECTT1.NodeID,T1.Caption--THIS IS WHERE YOU ADD THE CUSTOM PROPERTY TO BE VIEWED IN THE RESULTS,NCP.n_site--,NCP.area,n.Vendor,n.Description,COUNT (*) AS "Total Ports",SUM (IsUp) AS "Used Ports",SUM (IsDown) AS "Available Ports",CAST (ROUND ((1.0 * SUM (IsDown)/COUNT (*)) *100, 0) as float) AS "% Available"FROM (SELECT ND.Caption, ND.NodeID,CASE WHEN OperStatus = 'Up' THEN 1 ELSE 0 END AS IsUp,CASE WHEN OperStatus = 'Down' THEN 1 ELSE 0 END AS IsDownFROM NCM_Interfaces NCMIINNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID)INNER JOIN NodesData ND ON (NCMNP.CoreNodeID = ND.NodeID)WHERE (InterfaceTypeName like '%ethernet%')) T1JOIN Nodes n ON T1.NodeID=n.NodeID--THE FOLLOWING LINE JOINS THE CUSTOM PROPERTIES TABLEJOIN NodesCustomProperties NCP ON T1.NodeID=NCP.NodeID--THIS IS WHERE YOU WILL FILTER BASED ON THE CUSTOM PROPERTY VALUEWHERENCP.n_site LIKE 'wm%'--NCP.area LIKE '%noc%'GROUP BYT1.NodeID,T1.Caption,n.Vendor,n.Description--SINCE YOU ARE NOT DOING ANY CALCULATIONS ON THIS VALUE, IT NEEDS TO BE INCLUDED IN THIS GROUP BY STATEMENT,NCP.n_site--,NCP.areaORDER BY "Available Ports" DESC

While I am sure it can be done, I am not really sure how to go about doing the drop down menu.

However, if we convert this query into SWQL, we can use a custom query resource to use dynamic filtering, which would adjust the results on the fly, so to speak.

Let's start with this first, and see how close we are to getting the results you need. If I am way off, please let me know.

Thank you,

-Will

FormerMember

wluther,

Thanks and yes n_site is a customer property i have a couple of them, i will pop them at the bottom.

I popped the code and although the table creates but it is still not pulling any data in .

I have used UDT to port discover but would of assumed that NCM would do a more detailed interrogation.

as I used UDT would UDT be a more preferred way to pull the port data in?

Customer Properties

wluther

phillsb Yes, with UDT being an option here, I believe UDT would be the best place to get your numbers. While I am not certain, I think you would need to have NCM run an inventory job to have those details available. Perhaps cnorborg or vispetto would know better. Unfortunately, I do not have my lab environment running at this moment, so I am unable to verify anything with UDT.

What happens if you run the query below, commenting out the "WHERE" statement?

SELECTT1.NodeID,T1.Caption--THIS IS WHERE YOU ADD THE CUSTOM PROPERTY TO BE VIEWED IN THE RESULTS,NCP.n_site--,NCP.area,n.Vendor,n.Description,COUNT (*) AS "Total Ports",SUM (IsUp) AS "Used Ports",SUM (IsDown) AS "Available Ports",CAST (ROUND ((1.0 * SUM (IsDown)/COUNT (*)) *100, 0) as float) AS "% Available"FROM (SELECT ND.Caption, ND.NodeID,CASE WHEN OperStatus = 'Up' THEN 1 ELSE 0 END AS IsUp,CASE WHEN OperStatus = 'Down' THEN 1 ELSE 0 END AS IsDownFROM NCM_Interfaces NCMIINNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID)INNER JOIN NodesData ND ON (NCMNP.CoreNodeID = ND.NodeID)WHERE (InterfaceTypeName like '%ethernet%')) T1JOIN Nodes n ON T1.NodeID=n.NodeID--THE FOLLOWING LINE JOINS THE CUSTOM PROPERTIES TABLEJOIN NodesCustomProperties NCP ON T1.NodeID=NCP.NodeID--THIS IS WHERE YOU WILL FILTER BASED ON THE CUSTOM PROPERTY VALUE--WHERE--NCP.n_site LIKE 'wm%'--NCP.area LIKE '%noc%'GROUP BYT1.NodeID,T1.Caption,n.Vendor,n.Description--SINCE YOU ARE NOT DOING ANY CALCULATIONS ON THIS VALUE, IT NEEDS TO BE INCLUDED IN THIS GROUP BY STATEMENT,NCP.n_site--,NCP.areaORDER BY "Available Ports" DESC

Thank you,

-Will

cnorborg

Well, I'll answer the question about what do I need to do to make this happen first. UDT, NCM and NPM are the most likely candidates for pulling your data. But you have to remember how each module gets its data. UDT and NPM both have to be managing both the node AND the individual ports that you want to count. They both poll fairly often, although NPM is usually set to poll a bit more often than UDT. You'll have to check your polling intervals to know for sure how long you might need to wait for ports to have info in either module, I know I don't have them set to defaults on our system. The problem with this is that unless you're running with an unlimited license on these products, you will consume a lot more ports most likely. Not to mention the polling overhead of polling lots of unused ports. Even though we are running unlimited licenses I tend to not monitor unused ports, but this is a whole different discussion.

NCM might be better suited to your cause, because it will inventory the devices and their interfaces via the Inventory process and you can produce reports on all the interfaces on a device without having to add them to NCM, not that there is even a way to add an interface to NCM!! :-) The problem is that NCM inventory is a somewhat heavyweight process and is generally run on a schedule by you every week or so during off-hours. Depending on your server/environment it might not be desirable to try and run an inventory midday during the hours when people will have their computers turned on so it can catch the state of the port "correctly". Now if everyone in your company always leaves their computers on at night, running the report at night wouldn't be a bad thing, but...

That being said, the first SQL query you posted looks like it works well for me. Since this is using the NCM Interfaces table, make sure you run an inventory on the devices you want to be in the report. You can do that via "Configs" / "Config Management", then select the nodes you want and "Update Inventory". To schedule inventory updates, go to "Configs" / "Jobs" and there might be a default job that will update inventory that you might have to enable or run. If not, create your own job and have that run on a schedule. By creating your own, you can specify the sites to run on, or maybe the types of devices and such, very flexible...

Once you start getting data that you consider to be "good", its just a matter of modifying the query to include the other info you want, such as the Site. I believe the Site will need to be a custom property, or are you getting it another way? Knowing what you're using would help us to show you how to do that. I believe the Last Active could correspond to the "Last Change" field in NCM_Interfaces, which is nice. However, it isn't quite last active. ie: if the "OperStatus" field is "up", this will be when it went up. If the "OperStatus" field is "down" it will be when the interface went down. However, in either case, if the node was rebooted 6 hours before the Inventory was performed, I believe everything will end up being when it was last rebooted. I could be wrong, this could be something NCM figures out rather than polls, but I'm guessing its getting its data for this by polling the switch and not doing any interpretation on it.

HTH! Please ask questions, lots of stuff here that might be confusing. But knowing where you want to get your data from and how to interpret it is important when dealing with Orion!!

FormerMember

cnorborg (wluther)

Hello Craig. Many thanks for your response.

The SQL for the report has generated with some of the information that I am looking for. It was the Inventory that required updating that allowed the data within NCM to be used.

a bit of background - SW has been installed for over 1 year but due to the location it has been installed it has been a challenge to connect to all device across 3 different networks. 1 of the networks is being decommed, 2nd is new network, 3rd is for voice (no connection yet) the primary network is the 2nd.

SW is not been installed to make any changes to the devices but I am hoping in the future I will be able to make the case for SW to be the one tool that does all.

The key element is to be able to provide reporting on all devices as and when asked for and for a monthly report to be generated ( this would be several different reports) that have been set up and are ready to go and have been pulling in some data.

The reports that have already been setup (this was actioned by someone else who has now left) should provide all the data the support team requires so hopefully when all the nodes are correctly added these reports will be good.

With the new reports that I have to create (with the help of yourself and wluther (Thanks )) they are slightly different to what's been setup already.

Report to

report 1. identify Per Site (n_site) and Per Node (n_role) how many Total Ports / Used Ports /Available Ports / %available - Not to include any uplinks

report 2. on core/distribution switches (n_role) interface uplinks, interface and module type e.g. GigEther / Fibre SX or LX / Te's etc

I have got some custom properties setup and all fields for the nodes have been entered via the custom property editor. and I have also added details to some of SWs default properties as I thought this would also help.

I have scanned the network for all nodes on the primary network and although the scan picks them up the inventory does not -

Node Discovery - 531 nodes

Inventory update - 410 nodes

on Node discovery or UDT what should I select for discovery - Admin up/down /operational status/ Ethernet Gi TE etc.... Not selecting VLAN’s Port Channels etc... as this would be too many wasted ports even though I have unlimited.

The tools that I have are all unlimited, but not all up and running : -

3 x servers - Application / DB / NTA - running OS Server 2012

Application has 1 x polling engine (default)

NTA has 2 Poling engines - stacked I believe and I am trying to equal out nodes across the 2 servers however would prefer NTA server to be more of a primary poller than the Application server as this server is running all the apps

Orion Platform 2016.1.5300,

VNQM 4.2.4, installed not configured

IPAM 4.3, installed not configure

DPA 10.0.0, did not know we had it must be part of NPM12 update

NCM 7.5, installed working

IVIM 2.1.2, did not know we had it must be part of NPM12 update

QoE 2.1.0, Installed not configured

Toolset 11.0.3, installed

NetPath 1.0, Installed not used yet

NPM 12.0, Installed

NTA 4.2.0, Installed not used/configured

UDT 3.2.4 installed used but maybe not configured properly

back in July I updated all the applications to their latest version although I have not checked recently for any updates.

about me - Engineer/Design Architect, no knowledge of SQL or SWQL or reporting tool this is all new. I am trying to keep this tool as tidy as possible before it goes into production.

Again thanks in advance for any help

-Phillsb

cnorborg

Glad to hear your seeing data now! Yea, with all the components it can be a bit tricky sometimes figuring out how the info gets in there (ie: polled, inventoried, does the port have to be monitored, etc). Once you know a bit and sit down and think about it though, it all makes sense.

So, why are 531 nodes discovered and 431 inventoried? Good question. Are they all added to NCM? You can check that by going to Manage Nodes and there is a column that is NCM_Licensed. If you click on that, it will sort by it and make it easier to see if any aren't. To add them, select them and go to the "More Actions" on the menu bar, drop it down and choose "Add node to NCM".

If they are all in NCM, then you want to figure out which ones weren't inventoried. If you ran an inventory job, make sure you have "Save Job Log" configured under the "Enter Notification Details" when creating or editing the job. Then you can go to the "History" column in the "Jobs List" page and see what devices didn't inventory and why. Make sure you clear this history on occasion.

If you didn't run it as a job, and just did the nodes on demand, you can go to "Config Management" and the "Inventory Status" tab. You know, I'm not sure, the scheduled ones might show up here too. Usually the errors on why it didn't inventory are self-explanitory, but if you run into problems be sure to ask here.

Discovery Settings, it really depends on you and what you want! If you "Define Monitoring Settings", under "Interfaces" this is what NPM monitors. If you want to monitor ports that are down, you can, but I don't recommend it unless you have a need. Trunk and Access are just what you would think. A trunk port would usually be an uplink or some other type of port that is trunked (maybe to a VMWare host?), this is what I choose - I want uplinks but not end-user ports. An access port is usually to an end user. Unknown you usually get when its not Cisco or something odd. Physical would be an actual hardware port. Virtual would be something like a port-channel or a tunnel interface, something that doesn't exist as a physical port. Personally I would do Physical usually, although if there are port-channels I usually want to monitor them too. If it was important enough to create a port-channel, its probably important enough to monitor. Advanced settings are kind of neat, if you're consistent in setting interface descriptions, you can choose whether to monitor based off those for instance!!

The "Ports" setting is for UDT if I'm not wrong (haven't worked with 12 much). Usually you get the same questions like you do under interfaces, but I'm not seeing it in the "Define Monitoring Settings". For UDT I tend to NOT monitor trunk ports, but instead monitor end-user ports. That's because of how UDT works. UDT builds a table of MAC addresses and what ports it see's the MAC addresses on. It also loads all the ARP tables you have, which cross references MAC Addresses to IP addresses. Finally it builds a table of Active Directory log-ins and what IP address is associated with them. That way you can by looking at all this info, search for what port a person is on for instance. Now, if you monitor both end-user ports AND trunk ports, a users MAC address will be seen on both. And lets say the user has to hop through 5 switches to get to the router, their MAC address will be seen on ALL the uplink ports of those 5 switches! So, if you search for what port a user is on, not only should you get the port the user is on, but all of the uplink ports that it see's their MAC address on also. This is why I don't have UDT monitor uplinks!!

Solarwinds servers. If you have 3 servers for your entire solarwinds environment, the usual way to set them up would be to have one for your NPM database, which will also have other modules using it. The second server would be both your main poller and host all the modules. If you don't install all the modules on one server, you won't get full integration of them. The third server should be your NTA FSDB (Flow Storage Database) server. Because the type of data that NTA generates isn't conducive to working with an SQL database, you'll get way better performance setting up a separate server as the FSDB server, which is a NOSQL database. Takes tons of disk space and fairly intensive, so you don't want anything else on it. Your main poller will still get the Netflow data, but instead of storing it on your SQL server it will store it here. HIGHLY recommended...

Network: Why are you setting up two different networks? One for voice and one for data? You should be able to run them as one converged network with QoS configured quite well, and get better flexiblity. The money you'd save in the long run would more than pay for QoS training I would think!! If you're stuck on running a separate VoIP network, I would still connect it to your main network as maybe a VLAN so you can at least manage the devices fully from your main network. If you really don't want to do either, it should be possible to hook a second NIC into your solarwinds server and set up manual routes on the server so it can do this. HIGHLY recommended to do so!! Solarwinds will help you monitor and troubleshoot that network quite a bit!!

Just so you know, most of us started off as Networking folks with no SQL (and definitely no SWQL) training, so don't stop trying to learn!! But, having a good DBA care for your Solarwinds SQL server is a good thing!

Hope I covered everything... Lots of stuff in your last reply!

FormerMember

Hi Craig (cnorborg)

not sure how to reply back so added my response to you paragraphs....

I still have a fair bit of work to do to bring the application up to where I want it and this weeks not been a good week for time.

So, why are 531 nodes discovered and 431
inventoried?   Good question. Are they all added to
NCM?   You can check that by going to Manage Nodes and there is a
column that is NCM_Licensed. If you click on that, it will sort by it and
make it easier to see if any aren't.   To add them, select them and
go to the "More Actions" on the menu bar, drop it down and choose
"Add node to NCM".

Great – Many nodes not active in NCM
– this has been rectified.

If they are all in NCM, then you want to figure out which ones
weren't inventoried. If you ran an inventory job, make sure you
have "Save Job Log" configured under the "Enter Notification
Details" when creating or editing the job. Then you can go to
the "History" column in the "Jobs List" page and see what
devices didn't inventory and why. Make sure you clear this history on
occasion.

All nodes now in NCM

If you didn't run it as a job, and just did the nodes on demand,
you can go to "Config Management" and the "Inventory
Status" tab. You know, I'm not sure, the scheduled ones might
show up here too. Usually the errors on why it didn't inventory are self-explanitory,
but if you run into problems be sure to ask here.

Discovery Settings, it really depends on you and what you
want! If you "Define Monitoring Settings", under
"Interfaces" this is what NPM monitors.   If you want to
monitor ports that are down, you can, but I don't recommend it unless you have
a need.   Trunk and Access are just what you would think. A
trunk port would usually be an uplink or some other type of port that is
trunked (maybe to a VMWare host?), this is what I choose - I want uplinks but
not end-user ports.   An access port is usually to an end user.
Unknown you usually get when its not Cisco or something odd.
Physical would be an actual hardware port. Virtual would be something
like a port-channel or a tunnel interface, something that doesn't exist as a
physical port.    Personally I would do Physical usually,
although if there are port-channels I usually want to monitor them
too.   If it was important enough to create a port-channel, its
probably important enough to monitor.   Advanced settings are kind of
neat, if you're consistent in setting interface descriptions, you can choose
whether to monitor based off those for instance!!

The "Ports" setting is for UDT if I'm not wrong
(haven't worked with 12 much).   Usually you get the same questions
like you do under interfaces, but I'm not seeing it in the "Define
Monitoring Settings".   For UDT I tend to NOT monitor trunk
ports, but instead monitor end-user ports.   That's because of how
UDT works.   UDT builds a table of MAC addresses and what ports it
see's the MAC addresses on.   It also loads all the ARP tables you
have, which cross references MAC Addresses to IP addresses. Finally it
builds a table of Active Directory log-ins and what IP address is associated
with them. That way you can by looking at all this info, search for what
port a person is on for instance. Now, if you monitor both end-user ports
AND trunk ports, a users MAC address will be seen on both.   And lets
say the user has to hop through 5 switches to get to the router, their MAC
address will be seen on ALL the uplink ports of those 5 switches!
So, if you search for what port a user is on, not only should you get the port
the user is on, but all of the uplink ports that it see's their MAC address on also.
This is why I don't have UDT monitor uplinks!!

This I will need to set to be re discovered
then as I totally agree that UDT should only be monitoring end points

I will set NCM to rediscover all ports and monitor each interface port channel trunk etc

one thing I have now been asked to do is on slected code nodes to provide interface info on the uplinks

interface / port type Eth/Gi/Te - if fibre what Gbic SX or LX etc...this may be a challenge.

I assume that there may already be a predefined report to do this?

Solarwinds servers.   If you have 3 servers for your
entire solarwinds environment, the usual way to set them up would be to have
one for your NPM database, which will also have other modules using
it.   The second server would be both your main poller and host all
the modules. If you don't install all the modules on one server, you
won't get full integration of them.   The third server should be your
NTA FSDB (Flow Storage Database) server.   Because the type of data
that NTA generates isn't conducive to working with an SQL database, you'll get
way better performance setting up a separate server as the FSDB server, which
is a NOSQL database.   Takes tons of disk space and fairly intensive,
so you don't want anything else on it.   Your main poller will still
get the Netflow data, but instead of storing it on your SQL server it will
store it here.   HIGHLY recommended...

The setup is as you described – S1 =
Application server all Apps / S2 = DB
server only / S3 = NTA server and additional Poller/s

I have 4 additional pollers only 2
in use – 1 x poller is on the S1 giving total of 2 Pollers (1 is default) –
should the remaining pollers be installed on S3 making them staking/stackable
pollers?

Network:   Why are you setting up two different
networks?   One for voice and one for data?   You should be
able to run them as one converged network with QoS configured quite well, and
get better flexiblity.   The money you'd save in the long run would
more than pay for QoS training I would think!!    If you're
stuck on running a separate VoIP network, I would still connect it to your main
network as maybe a VLAN so you can at least manage the devices fully from your
main network.   If you really don't want to do either, it should be
possible to hook a second NIC into your solarwinds server and set up manual
routes on the server so it can do this.   HIGHLY recommended to do
so!!   Solarwinds will help you monitor and troubleshoot that network
quite a bit!!

Sorry miss directed you ,VoIP is using the same network but the back where the CUCM servers are they are on a
separate network out of my control. still be able to reach them but it has not been a priority as the user data network is more of priority than VoIP. Yes I would like to use the QoS. I have not looked into it, and again I'm not a VoIP expert (yet) with knowledge of how to integrate this with the CUCM servers. Assuming SolarWinds will need to interrogate the CUCM servers?

Regards

-Phill

cnorborg

So, are AP ports trunked? If not, that could be a problem.

I still think you might have an easier time if you had consistent interface descriptions, wouldn't have to leverage so many tables from different sources to try and come up with your report. If you were to do something like "UPLINK" in the description of your uplink ports (whether or not they're trunked) you'd know they're not chargeable. Plus, you'd be able to find it easy rather than having to cross reference different tables. You could also put in stuff like SX and LX in that description too to make searching for that type of stuff easy for reporting purposes. If you really wanted to get ambitious, you could do something like "CHARGEABLE" or "USER" or "ACCESS" or something to signify that this is a port you should charge for. Takes some work to get set up initially, but it could make your reporting life easier in the long run.

You could then make a quick report or resource that would search for trunk links that didn't have a valid description, or ports in general. Then you'd just have to go fix the descriptions on those ports and you're reporting would be good.

Hopefully that's enough to get you on your way to producing the reports you need!! Doing the whole interface description thing could make this easier too, rather than having to do custom SWQL queries if you leverage the interface description you could probably use the query builder to do your work for you too...

As for the poller not working? Not enough details to even guess. I'd recommend opening a ticket with support on that, they can probably fix you up really quick!

Good luck!

rschroeder

I use this method to discover ports on specific switches that have not been used recently. It enables me to recover ports going to removed PC's or printers, thus allowing me to re-use those switch ports and saves me the cost and hassle of buying additional switches.

How to create a report displaying the Last Time Data was Transmitted or Received on a Switch Port

It sounds like you're hoping to find a more global report, instead of one targeting specific switches; is that true?