Forum Discussion
aswinnen_6967
Aug 14, 2018Nimbostratus
I think the following query is more useful, as it lists which signatures are assigned to which signature set:
mysql -uasm -p`perl -I/ts/packages -MF5::Cfg -e 'print F5::Cfg::get_mysql_password()'` PLC -e "
select
PLC.NEGSIG_SETS.set_name,PLC.NEGSIG_SET_SIGNATURES.set_id,
PLC.NEGSIG_SET_SIGNATURES.sig_id,PLC.NEGSIG_SIGNATURES.sig_name,
from
PLC.NEGSIG_SETS,PLC.NEGSIG_SIGNATURES,PLC.NEGSIG_SET_SIGNATURES
where
PLC.NEGSIG_SETS.set_id = PLC.NEGSIG_SET_SIGNATURES.set_id
and PLC.NEGSIG_SET_SIGNATURES.sig_id = PLC.NEGSIG_SIGNATURES.sig_id
order by
set_name,PLC.NEGSIG_SIGNATURES.sig_id ;"
> /var/tmp/device-signature-set.out