/*

Pentana Audit - Find SignOffs with missing user info

Purpose of script:
    
    Identifies any SignOff rows that are missing user information.  

    Any rows returned by this script will need to be fixed - see KB article 'Pentana Audit:  Sign Off state cannot be changed'.  

*/

SELECT * FROM [SignOff] WHERE CreatedByID IS NULL;