Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: [SPAM?] Re: [EXTERNAL]: Re: Custom filters based upon
additional networks data table (Nick Nauwelaerts)
--- Begin Message ---
ok,
let me know if i'm getting this correct. the report you're trying to run is the
same, the only option that changes is the "bu"?
if so we could have an option for you, if you scroll down under
https://github.com/netdisco/netdisco/wiki/Configuration#reports you'll find
https://github.com/netdisco/netdisco/wiki/Configuration#bind_params-optional .
while the example given first for reports is static, using bind params enables
you to have parameters for your custom report, so if all you need is to change
the "bu" and the rest is the same this could be solution. i don't think however
this has any sidebar support, so you'll actually need to fill in the parameters
in the url (examples are given).
for full sidebar support you'll most likely need to have a look at
https://github.com/netdisco/netdisco/wiki/Web-Plugins and perhaps even change
the database stuff under
https://github.com/netdisco/netdisco/tree/master/lib/App/Netdisco/DB to get
your added columns known, which will most likely also lead to
https://github.com/netdisco/netdisco/wiki/Developing
we also really don't recommend changing the netdisco schema, for this you can
use https://github.com/netdisco/netdisco/wiki/Configuration#external_databases
which is supported by reports, but it seems we don't have an example of that in
our docs yet.
bottom line, if sidebar support is needed you might be stuck with writing a
plugin, if you can live with hand editing the url our current report support
could be all you need. changing the netdisco db schema we don't recommend.
if you need more interactive support we are on irc, but replies can take a bit.
// nick
From: Greene, Joseph [mailto:[email protected]]
Sent: Tuesday, November 5, 2019 15:23
To: Christian Ramseyer <[email protected]>
Cc: [email protected]
Subject: [SPAM?] Re: [Netdisco] [EXTERNAL]: Re: Custom filters based upon
additional networks data table
I tried using a plugin and kept running into the wall. the most recent idea
I've tried is adding a field to the devices table as it looks like it builds
query possibilities/filter options by getting the list of DB fields. I still
am not seeing the field on the web interface of course because nothing is built
to display that field. I suppose I could try modifying the base code to make
certain an array is made out of the field's unique value and then just add the
filter code to the report templates . I think I should be able to search
against the field if I can figure out how to add the field to the advanced
search page(s).
Joe Greene
Ascension Information Services - Network Management Tool Administrator
Cell: 317-7858-TOOL (8665)
On Tue, Nov 5, 2019 at 9:14 AM Greene, Joseph
<[email protected]<mailto:[email protected]>> wrote:
The problem with that is I have to have 35 regions upon which to filter for
these reports, I need these filters available for pretty much all reports and
that means each port utilization, node and devices report times 35 which
results in a menu so long it cannot display all of those report options, no
matter how you work it.
Joe Greene
Ascension Information Services - Network Management Tool Administrator
Cell: 317-7858-TOOL (8665)
On Wed, Oct 23, 2019 at 4:39 PM Christian Ramseyer
<[email protected]<mailto:[email protected]>> wrote:
On 23.10.19 21:17, Greene, Joseph wrote:
> We have a corporate environment with 35+ varying logical business units
> amongst which we assign various subnets.
> We have a table (call it our_networks) which maps network (type CIDR)
> to Business unit (bu type text) and State (state type text).
> We need to perform searches/run reports against all devices in a given
> BU. Trying to do this we end up having top make 35 reports and make a
> new one every time we add or subtract a bu. it would be preferable to be
> able to make a single report, add a field to devices for the bu, update
> that bu via nightly task and add a dropdown on the sidebar allowing
> filtering based on unique bu values. I've tried as few approaches but
> have been bouncing off this wall for months like a racquetball. I'm not
> finding a means of adding this bu to devices and making it filterable
> without significant base code changes.. am I missing something? I'm
> starting to feel like I missed some simple detail.. I did add bu to our
> netdisco devices table as part of my efforts and populated it as well.
> so the database part should be addressed, it's just the display and
> filter part that has me baffled.
>
>
Hi Joe
I'm probably not seeing the whole picture yet. If you just add a report
like shown in
https://clicktime.symantec.com/3TUUGhKRaSom8vYbi14zBQW7Vc?u=https%3A%2F%2Fgithub.com%2Fnetdisco%2Fnetdisco%2Fwiki%2FConfiguration%23reports
E.g.
reports:
- tag: power_inventory
label: 'Power Supply Inventory'
category: Device
columns:
- {name: 'Name'}
- {ps1_type: 'PS1 Type'}
- {ps1_status: 'PS1 Status'}
- {bu: 'Business Unit'}
query: |
SELECT
d.name<https://clicktime.symantec.com/38AvaxoajACdoisJe6RwAMQ7Vc?u=http%3A%2F%2Fd.name>,
d.ps1_type, d.ps1_status, d.bu
FROM device d
ORDER BY name
and then filter the BU with the "Filter records.." box in the HTML page,
what is it exactly that you're missing from there?
In general, if the simple reports configuration in deplyoment.yml
doesn't cut it, you might have more luck with making a specific Web
Plugin as described in
<https://clicktime.symantec.com/3TDXcKkHs3W6djuaf7Ty9dt7Vc?u=https%3A%2F%2Fgithub.com%2Fnetdisco%2Fnetdisco%2Fwiki%2FWeb-Plugins>..
but maybe
you've looked at this already as well?
If you can post some details of where you're stuck at, what these
searches/report exactly should contain etc. we can give you better advice.
Cheers
Christian
________________________________
Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> |
Twitter<https://twitter.com/aquafinnv> |
YouTube<http://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee> |
LinkedIN<http://www.linkedin.com/company/aquafin/products> |
Instagram<https://www.instagram.com/aquafin_nv/>
In het kader van de uitoefening van onze taken verzamelen we bij Aquafin
persoonsgegevens. Hoe we omgaan met deze gegevens en wat de rechten van de
betrokkenen zijn, kan je nalezen in onze privacy
policy<https://www.aquafin.be/nl-be/privacy-policy>.
P Denk aan het milieu. Druk deze mail niet onnodig af.
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
