#Dyn updater host status inactive how to#
While I am sure it can be done, I am not really sure how to go about doing the drop down menu. SINCE YOU ARE NOT DOING ANY CALCULATIONS ON THIS VALUE, IT NEEDS TO BE INCLUDED IN THIS GROUP BY STATEMENT THIS IS WHERE YOU WILL FILTER BASED ON THE CUSTOM PROPERTY VALUE THE FOLLOWING LINE JOINS THE CUSTOM PROPERTIES TABLE WHERE (InterfaceTypeName like '%ethernet%') INNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID) THIS IS WHERE YOU ADD THE CUSTOM PROPERTY TO BE VIEWED IN THE RESULTS I simply spaced it out a bit more to make it easier to see what should go where.Īlso, 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. The query below is actually the same as the one you previously provided. JOIN NodesCustomProperties NCP ON T1.NodeID=NCP.NodeIDįiltering by the "n_site" values contained within the "NodesCustomProperties" table:Īdding the "n_site" column to the SELECT statement, making the values visible in the returned results:Īdding the "n_site" custom property to the GROUP BY statement: Joining the "NodesCustomProperties" table to the query: 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: If anyone is able to proide some advice it would be appreciated.Īre you using "n_site" as a custom property, or does it represent something else?
#Dyn updater host status inactive code#
WHERE (InterfaceTypeDescription like '%ethernet%')īoth code and image is from Port count report INNER JOIN NodesData ND ON (NCMNP.CoreNodeID = ND.NodeID) What do I need to do,to make this happen?ĬOUNT (*) AS "Total Ports", SUM (IsUp) AS "Used Ports", SUM (IsDown) AS "Available Ports"ĬASE WHEN OperStatus = 'Up' THEN 1 ELSE 0 END AS IsUp,ĬASE WHEN OperStatus = 'Down' THEN 1 ELSE 0 END AS IsDownįROM NCM_Interfaces NCMI INNER JOIN NCM_NodeProperties NCMNP ON (NCMI.NodeID = NCMNP.NodeID)
i will add the modified code when i logged in. I have modified the below code to include some more columns and info, but still no data. To keep things simple I only discovered 1 site for its ports, but nothing is showing in the table. I have found the following code and applied it and it looks good but the code is not pulling in any data. The task is to provide a report that shows. I am new to SW and I have been tasked to produce a report for all sites Approximately 600 Cisco nodes. 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. Would someone please provide some assistance please.
0 kommentar(er)
