SQL query to get newly created projects for the specified(May) month from ALM Database

  • Questions
  • SQL query to get newly created projects for the specified(May) month from ALM Database
Question ID: 106894
0
0

Need a SQL query or any other ways to know the newly created projects in ALM in a specified month. please help me on my question.

Marked as spam
Posted by (Questions: 23, Answers: 3)
Asked on May 30, 2016 10:32 am
9 views
Answers (1)
0
Private answer

As of version 11.52, when a new project is created the date and time of creation are added to the Description field for the project. This field is in the PROJECTS table in the Site Admin schema.

Do you need help building the query itself, or is that enough info to get you started?

Marked as spam
Posted by (Questions: 1, Answers: 101)
Answered on June 4, 2016 6:09 am
Hi @tclasp Thanks for your reply and yes I saw that description column in the Site admin schema and it has the value like 'Created on xx/xx/xxxx'' and I have tried to convert into Date format to use in SQL query but I could'nt kindly please help on build a query also.
( at June 4, 2016 2:24 pm)