Community
Q&A
Confluence
Questions
How many spaces have i created this year?

How many spaces have i created this year?

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

Hey Victor,

To separate personal space count and global space count

SQL Queries

select COUNT(*) from SPACES WHERE CREATIONDATE &gt;= '2016-01-01' AND SPACETYPE = 'personal';
---------------------------------------------------------------------------------------
select COUNT(*) from SPACES WHERE CREATIONDATE &gt;= '2016-01-01' AND SPACETYPE = 'global';

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Hi Victor,

Here is the DB query executed against SQL Server

select COUNT(*) from SPACES WHERE CREATIONDATE &gt;= '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.

Comment

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.

Comment

Was this helpful?

Thanks!

Confluence

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How many spaces have i created this year?

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events