This app is invaluable for these types of questions https://mactracker.ca. Source: about 1 year ago

I use a tool called Mactracker. They update frequently to keep up with obsolete/vintage status and have a macOS app and iOS app. If you click the Software tab in the app you'll get Maximum OS. Https://mactracker.ca/. Source: about 1 year ago

You can also use the mac app Mactracker -> https://mactracker.ca/. Source: over 1 year ago

I remember running into a FileMaker database file which contained a list of all Mac hardware, including playable embedded AIFF files of what their startup chimes sounded like. I feel like a librarian in the Library of Babel talking about the pre-prehistoric Internet. Then again, maybe it was an old version the MacTracker app: https://mactracker.ca. - Source: Hacker News / over 1 year ago

Which is all interesting as the screen they are showing I think is high Sierra which supposedly the early 2009 couldn’t run only the late 2009. As per the mactracker app. Source: over 1 year ago

I'm not sure it'll check all your boxes, but it should check most of them. Hippo CMMS is what we use for maintenance at our centre and it works pretty well. Works on mobile, ties in with Azure which is nice. I haven't dug into their inventory capabilities, but their reps have been helpful with questions and I'm sure could give you more info. Source: over 2 years ago