How many spaces have i created this year?

Victor Prasad April 25, 2016

Hello,

I was asked 'how many spaces were created this year'.

Can I search by sites created by date?  Or is there a db query I can run?

Help, please?

Thanks,

Mr. V

2 answers

1 accepted

3 votes
Answer accepted
Chander Inguva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 25, 2016

Hey Victor,

                 To separate personal space count and global space count

SQL Queries

select COUNT(*) from SPACES WHERE CREATIONDATE >= '2016-01-01' AND SPACETYPE = 'personal';
---------------------------------------------------------------------------------------
select COUNT(*) from SPACES WHERE CREATIONDATE >= '2016-01-01' AND SPACETYPE = 'global';
1 vote
Chander Inguva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 25, 2016

Hi Victor,

              Here is the DB query executed against SQL Server

select COUNT(*) from SPACES WHERE CREATIONDATE >= '2016-01-01';

Regards

Chander Inguva

Victor Prasad April 25, 2016

Thank you for your fast help!

Any way to separate out personal spaces from other spaces (team, project, etc)?

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events