So, yes, but...
To accomplish this In my Jamf instance one of the searches you would need to build would look like this:
However, that is relying on a custom extension attribute I wrote to get the year from the Marketing Model name which I posted here... If you don't use that there isn't a good way to build a Smart Group that finds computers by model year (which is why I wrote it.😶 )
Another issue is "total number of Macs in Jamf." When you build a search that defines a criteria that some devices in your fleet match & some don't you are de facto creating a subset of your total number of devices.
So, you will need to create a 2nd search that just has everything, i.e., save it. just don't put any criteria in it.
So, what would have is 2 .csv files. 1 would basically be your "report" the other is simply a single-column list of all of your computers. If you remove the 1st line of that .csv (i.e., the header) & count the lines you could easily pop that value into your other .csv e.g.,
% sed '1d' Everything.csv | wc -l
912
% total="$(sed '1d' Everything.csv | wc -l)"
Description,Number
Total number of Macs in Jamf,"$total"
Total number of Macs with agent installed,1234
Total Unsupported Macs (older than 5 years - iMacs included),1234
Total number of Macs checked-in less than 30 days,1234 Your script would have 2 api calls to the 2 searches & a little computer magic to make a single .csv - then you need something to send the email. I have done this kind of thing with Python smtplib in the past. Let me know if you have other questions!
