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: [EXTERNAL]: Re: Custom filters based upon additional
networks data table (Greene, Joseph)
2. Re: [EXTERNAL]: Re: Custom filters based upon additional
networks data table (Greene, Joseph)
--- Begin Message ---
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]>
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, 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
>
CONFIDENTIALITY NOTICE: This email message and any accompanying data or files
is confidential and may contain privileged information intended only for the
named recipient(s). If you are not the intended recipient(s), you are hereby
notified that the dissemination, distribution, and or copying of this message
is strictly prohibited. If you receive this message in error, or are not the
named recipient(s), please notify the sender at the email address above, delete
this email from your computer, and destroy any copies in any form immediately.
Receipt by anyone other than the named recipient(s) is not a waiver of any
attorney-client, work product, or other applicable privilege.
--- End Message ---
--- Begin Message ---
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]>
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]>
> 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
>>
>
> CONFIDENTIALITY NOTICE:
> This email message and any accompanying data or files is confidential and
> may contain privileged information intended only for the named
> recipient(s). If you are not the intended recipient(s), you are hereby
> notified that the dissemination, distribution, and or copying of this
> message is strictly prohibited. If you receive this message in error, or
> are not the named recipient(s), please notify the sender at the email
> address above, delete this email from your computer, and destroy any copies
> in any form immediately. Receipt by anyone other than the named
> recipient(s) is not a waiver of any attorney-client, work product, or other
> applicable privilege.
> _______________________________________________
> Netdisco mailing list
> [email protected]
>
> https://clicktime.symantec.com/a/1/NUuK29XsAotK7jjsXcD-3G8qd0L8g5bF-oOJilKH5IM=?d=kXx_yTwwAQOuY7JQp-DCfX0Js-gkA6ILL66Z5GSn-tIz0_rxXV33bOFWkN5qpfwsVaVB8qVf4WB84mfMfn7_ZA2ul5KXhtsb3XgNB2yL4rutPs6y2LC4_e3ik7n_pZ_6p-ML0kFsBa_PDsmsx-Xt_E5C07vJrlOGgL1iQOk0Z1SJ6VzkDXuNS56Vb0Z8KRUsDQ3JcgWSZCyOvTlRzboSfOz03XbrP81f5v8KSGVutCB-3jLvJUTo2zV9ctf8ed-rcRq7DKBFokau6qEpiDjs6TjvU3crVQyf-0NIENB0LYydQQMVdjtVD4_TDfIqTHFfUknqy11EazhZ-muf0uLQ-S_yqI1G-8yleXqrsS5sFjciGmQ9Q5ada54T8i9Wk6Qj1JPkX6S86nkfUokFAfOoZ4IH91XzV0vdHRwyxh6Wlt-LgoPQ-82GCAplS7qKKuuIu1K6feES8q3K73BR5Q3BCnlYNTIbWMW3QPmQbMHvqIct-U9Ua3pHjZovMsgi8-R8x8aMnVGgLVv06loNkeOt4gKEmdMIOyyOTx3HxXKSstzTHcOY_Ye9owb5XLM5U7GfIsH5OGOgqg%3D%3D&u=https%3A%2F%2Fsourceforge.net%2Fp%2Fnetdisco%2Fmailman%2Fnetdisco-users%2F
CONFIDENTIALITY NOTICE: This email message and any accompanying data or files
is confidential and may contain privileged information intended only for the
named recipient(s). If you are not the intended recipient(s), you are hereby
notified that the dissemination, distribution, and or copying of this message
is strictly prohibited. If you receive this message in error, or are not the
named recipient(s), please notify the sender at the email address above, delete
this email from your computer, and destroy any copies in any form immediately.
Receipt by anyone other than the named recipient(s) is not a waiver of any
attorney-client, work product, or other applicable privilege.
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
