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
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';
Hi Victor,
Here is the DB query executed against SQL Server
select COUNT(*) from SPACES WHERE CREATIONDATE >= '2016-01-01';
Regards
Chander Inguva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your fast help!
Any way to separate out personal spaces from other spaces (team, project, etc)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.