5 Replies Latest reply on Apr 27, 2012 9:13 AM by Ravi Teja

    lockDomain

    Sean Bolton
    Sean Bolton Apr 23, 2012 4:00 PM

      If i do a back end SQL query on the documents table there is a field called "LockDomain" this represents the user that has the file locked....  Is there a way through the search feature that i can find this information ?  I do not want to give people access to the sql database just to figure out who has a document locked... Thanks in advance

      • 973 Views
      • Categories: Data Management, Enterprise PDM
      • Tags:
        • Re: lockDomain
          Raghavendra Bhagwan
          Raghavendra Bhagwan Apr 23, 2012 11:59 PM (in response to Sean Bolton)

          Dear Sean,

           

          There is an Out of the box search feature available for the users to find out the files that are checked out / checked in in the vault.

           

          Please click on the complete search in your vault view > Click on the Checked in /out tab and select a user to find out if he has some file that are checked out.

           

          I am attaching the same for your better understanding.

           

          Hope this helps !

           

          Cheers !

          Raghav

            • Re: lockDomain
              Sean Bolton
              Sean Bolton Apr 26, 2012 4:57 PM (in response to Raghavendra Bhagwan)

              what I am looking for are files that are pre PDM Check-in, meaning the file has not entered the workflow yet (the end user has pulled a new serial number, but no one else can see it but that user).  What is happening is our counter skips a number, and someone comes to me telling me that the counter is off, then I have to either ask everyone that has access to creation of that serial number or have a sql admin run a query like  

               

              select FileName,LockDomain from Documents where FileName='xyz.SLDDRW'

                • Re: lockDomain
                  Einar Gulbrandsen
                  Einar Gulbrandsen Apr 27, 2012 3:56 AM (in response to Sean Bolton)

                  You can use the same procedure as Raghavendra Bhagwan has suggested, but you have to use the built in admin user to do this.

                   

                  The built in admin user has built in functions that no other user has.

                   

                  Such as :

                  to see at file that are not in the work flow.

                  undo chekout another users files

                  check in another users files

                  • Re: lockDomain
                    Raghavendra Bhagwan
                    Raghavendra Bhagwan Apr 27, 2012 4:54 AM (in response to Sean Bolton)

                    Hello Sean,

                     

                    Skipping of serial numbers ? i know where the problem could be.

                     

                    Check the file data card for variable which is connected to serial number to ensure that "UPDATE ALL CONFIGURATIONS" option is checked.

                     

                    The reason why this happens when a part file is added to vault, EPDM By default creates two tabs in the Data card, 1) @ and  2) Default.

                     

                    So the serial number is triggering twice.

                     

                    Hope this helps.

                     

                    Regards,

                    Raghav.

                • Re: lockDomain
                  Ravi Teja
                  Ravi Teja Apr 27, 2012 9:13 AM (in response to Sean Bolton)

                  Hi Sean,

                              The Documents added but not checked in,will burn a serial and is visible to the user who added it and to te admin this file is said to be in "Private state".

                   

                              You can use report generator in EPDM to show this LIST to users using SQL query in crp report.

                              

                  REPORT GENERATOR is a READ ONLY tool.

                   

                   

                   

                   

                  Regards

                  Ravi T