@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