Community
Buy or Renew
EN US
Chinese
EN US
French
Japanese
Korean
Portuguese
Spanish
Log In
MENU
CLOSE
Buy or Renew
Log In
EN US
Chinese
EN US
French
Japanese
Korean
Portuguese
Spanish
Cisco + Splunk: It’s a new day for your data. Learn more.
RowanMark
Level 1
Member since
09-22-2005
08-18-2017
Recent Badges
Awards
User Statistics
1
Posts
0
Solutions
0
Helpful votes Given
0
Helpful votes Received
Cisco Community
About RowanMark
Please click
here
to merge your Webex community account with this Cisco.com community account
User Activity
Posts
Replies
No posts to display.
Re: Corporate Directory - SQL
09-22-2005
Is this something you were looking for?2 seperate scriptsselect num.DNOrPattern Ext, dev.description Owner, right(dev.name, 12) MAC, typ.name Model, loc.name Location from dbo.device dev inner join dbo.devicenumplanmap dvn on dev.pkid = dvn.fkDev...
Community Statistics
Member Since
09-22-2005
09:56 AM
Date Last Visited
08-18-2017
03:54 AM
Posts
1