I need to write a report that shows warranty expiration dates of our Dell servers that are expiring within 90 days using SAM (since it gives us that info). I went into report writer but didn't see anything like that when I go to new report.
Have you tried using the Warranty Status Report pictured below?
Looks like a custom written report to me. That's not a canned report...
That is a canned out-of-the-box report included with SAM 6.0. It leverages the new web based Report Writer that's also new in SAM 6.0. So you won't find it in the legacy Win32 base Report Writer.