Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-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 Netdot-users digest..."
Today's Topics:
1. Re: Help with SQL query (Carlos Vicente)
2. Re: Help with SQL query (Stafford Rau)
----------------------------------------------------------------------
Message: 1
Date: Wed, 9 Mar 2016 16:32:33 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Help with SQL query
To: Stafford Rau <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Hi Stafford,
Try this:
mysql> select rr.name, device.os from rr,device,asset,product where
device.name=rr.id and device.asset_id=asset.id and asset.product_id=product.id
and product.name="29xxStack?;
cv
On Mar 9, 2016, at 12:50 PM, Stafford Rau <[email protected]> wrote:
> Let me preface this with the fact that my SQL knowledge is pretty rudimentary.
>
> I'll like to get a list of all of our switches in netdot that are
> product.name = "29xxStack", and display the device.name and device.os.
>
> Anyone willing to give me a quick cheat for that?
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 2
Date: Wed, 9 Mar 2016 15:08:46 -0800
From: Stafford Rau <[email protected]>
Subject: Re: [Netdot-users] Help with SQL query
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
<CAAquA9GNWt8A3vMc8=uz5BF3zQOpim=4vqkbdqaaa_aq5hm...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
That worked perfectly!
Thanks much,
--Stafford
On Wed, Mar 9, 2016 at 1:32 PM, Carlos Vicente <[email protected]>
wrote:
> Hi Stafford,
>
> Try this:
>
> mysql> select rr.name, device.os from rr,device,asset,product where
> device.name=rr.id and device.asset_id=asset.id and asset.product_id=
> product.id and product.name="29xxStack?;
>
>
> cv
>
> On Mar 9, 2016, at 12:50 PM, Stafford Rau <[email protected]> wrote:
>
> > Let me preface this with the fact that my SQL knowledge is pretty
> rudimentary.
> >
> > I'll like to get a list of all of our switches in netdot that are
> product.name = "29xxStack", and display the device.name and device.os.
> >
> > Anyone willing to give me a quick cheat for that?
> > _______________________________________________
> > Netdot-users mailing list
> > [email protected]
> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20160309/4016a70c/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 84, Issue 2
*******************************************
