• Query for Users and their Security Groups

    Hi, I just want to ask for an SQL query for the security group each users belong? Thanks and regards, Bryan
  • PPM Support Tip: Project Settings in a combination of tables

    When looking for Project Settings in the database, a combination of tables must be used. A client was trying to find the Project Settings for Projects in the schema. To find the settings for Projects, need the combination of the follow tables: PM_PROJECTS…
  • PPM Support Tip: Use 'Resource' "Group By" Field when running Actual Time Summary Report

    When running Actual Time Summary Report without 'Resource' "Group By" Field, Report returns a much larger Total Actual Cost than what is expected Time Management issue found in 9.21 - Use 'Resource' as a "Group By" filter The inconsistencies arise when…