How many spaces have i created this year?

[Victor Prasad]

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

[Chander Inguva · Accepted solution]

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';

[Chander Inguva]

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]

Thank you for your fast help!

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