Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @echo off
- echo Started %DATE% %TIME%
- :addbuttons
- call:countdelredir
- echo Adding Rediscover button to device details page...
- mysql nms2 -e "replace into properties (select dev_properties, 'Rediscover',18,concat('<script src=\"../custom/delredir.js\"></script><img BORDER=0 src=\"images/refresh2.gif\" onClick=\"xr(\'',smgr_host,'\',\'',dev_name,'\');\">') as property_value,0,0 from devices, service_managers where dev_owner=smgr_id);"
- echo Adding Delete button to device details page...
- mysql nms2 -e "replace into properties (select dev_properties, 'Delete',18,concat('<script src=\"../custom/delredir.js\"></script><img BORDER=0 src=\"images/RedDelete.gif\" alt=\"Delete\" onClick=\"xd(\'',smgr_host,'\',\'',dev_name,'\');\" />') as property_value,0,0 from devices, service_managers where dev_owner=smgr_id);"
- REM mysql -D nms2 -P 3308 < device_details_rediscover_deletev2.sql
- call:countdelredir
- :addproperties
- call:countdevices
- call:countproperties
- echo Adding SNMP details to properties for each device...
- call:insert "'sysDescr', 18, sys_descr,"
- call:insert "'sysObjectID',18, sys_objectid,"
- call:insert "'sysName', 18, sys_name,"
- call:insert "'sysContact', 18, sys_contact,"
- call:insert "'sysLocation', 18,sys_location,"
- mysql -P 3308 nms2 -e "replace into properties select dev_properties,'Last Discovered', 18, from_unixtime(dev_discovered),0,0 from devices;"
- mysql -P 3308 nms2 -e "replace into properties select dev_properties,'Last Modified', 18, modified,0,0 from devices;"
- call:countproperties
- :: Finish/Cleanup
- echo Finished %DATE% %TIME% & echo ---------------------------------------------------------------
- GOTO:EOF
- :insert
- set inspropsql=mysql nms2 -e "replace into properties (select dev_properties,
- set inspropsql2=0, 0 from devices where snmp_capable^<^>0)"
- %inspropsql% %~1 %inspropsql2%
- GOTO:EOF
- :countproperties
- mysql nms2 -e "select property_name as Property, count(*) as 'Devices with Property' from properties where property_name in ('sysDescr','sysObjectID','sysName','sysContact','sysLocation') group by property_name;"
- GOTO:EOF
- :countdevices
- mysql nms2 -e "select count(*) as 'Total Number Devices with SNMP Details' from devices where snmp_capable<>0;
- GOTO:EOF
- :countdelredir
- echo Device Details Page Delete/Rediscover buttons present on:
- mysql.exe -D nms2 -P 3308 -e "select property_name as Property, count(*) as 'Devices with Property' from properties where property_name in ('Rediscover','Delete') group by property_name;"
- GOTO:EOF
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement