I'm looking for some SQL that will extract all the devices in Micros. For example, the device name, device number, IP number, etc. It can be the whole table and I will parse out what I don't want. I dumped out the device table but it didn't list my Sar/Win station client ip numbers. I'm using this info to provide it quickly to our PCI compliance group. My only other option(that I know of) is to just do print screens from the workstations window and retype into excel or word. Thank you in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micros 9700 Device Listing
- Thread starter mdsmith99
- Start date
It's been a while since I played around with a 9700 database.. But in the 3700 database there is a device node table which contains the IP address information, and then the actual device table which contains the specifics about the workstations. I imagine that 9700 is similar, so the SQL would be something like
SELECT nodes.ip_address, devices.*
FROM micros.node_table AS nodes
JOIN micros.device_table AS devices
ON node.device_id = devices.device_id
SELECT nodes.ip_address, devices.*
FROM micros.node_table AS nodes
JOIN micros.device_table AS devices
ON node.device_id = devices.device_id
- Status
Similar threads
