We want to get a report out of our SDP's CMDB to detail the growth in the number of servers for the last 3 weeks.

Next step would be to correlate with previous periods to estimate how fast that number grows, so we can then order the correct number of antivirus licenses based on that.

I'd think writing a query report and looking for things like 'creation date', then doing the same for the previous month and so on but I can't seem to build the correct query to do just that.

Does anyone have any idea?