I'm looking for a way to reset the database on my QPM install without having to reinstall QPM and patch it up again. The reason for this is we've ended up with a number of ghost nested policy entries that are selectable in policy creation but do not show up in the nested policy table (provisioning > pre-configuration > nested policies), and some policies cannot be deleted (after selecting them and pressing delete they are still in the policy list!).
Alright, I'd still strongly suggest completing a backup from QPM's Common Services first before you go ahead. That being said, I'm guessing you could get it done with the following commands on the appropriate OS:
/opt/CSCOpx/bin/dbRestoreOrig.pl dsn=qpm dmprefix=??? <-- see note below
net stop crmdmgtd
NMSROOT\bin\perl.exe NMSROOT\bin\dbRestoreOrig.pl dsn=qpm dmprefix=??? <-- see note below
Now the ??? part is what I'm not sure about. My bet would be either "QPM" or "Qpm", but I can't find any definitive answer about it. So YMMV, No Warranty Expressed or Implied, etc., etc.