nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Chander Inguva

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

All comments

Chander Inguva

Hi Victor,

Here is the DB query executed against SQL Server

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

Chander Inguva

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration