Month End Reporting

Posted on 2014-01-15
Last Modified: 2014-02-03
Hi Experts,

I know that most of us do Month End reports on our various Infrastructures and there are many tool out there that do it some good some not so good.  Im looking for something that will give me an in depth report on the status of some of the critical systems in an infrastructure (Tags above) possibly a PS script that will go through my infrastructure and compile the information in html or something.

I know im looking for a quick fix, but Month end reporting is taking up way too much of my time as I have to scour though various tools and put it into a report.

Question by:damejen
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
LVL 43

Expert Comment

ID: 39795804
Please have a look at LANSweeper  I used it extensively in my last place of work.  It relies on WMI (Microsoft) but it certainly was able to capture as much info as I needed at the time to report on.

Certainly work a look.
LVL 94

Expert Comment

by:John Hurst
ID: 39795807
If you want a quick fix, you need to use the month end reporting of your financial system (QuickBooks, Simply Accounting or whatever).

If you want a proper and long term fix, create a report format with Actual, Budget and Last Year for operations and a comparative Balance Sheet. Export data from your accounting system into worksheets and then make formulas to extract data from the worksheets into the two report sheets (Operations and Balance Sheet).

... Thinkpads_User
LVL 43

Expert Comment

ID: 39795831
Is this a financial or infrastructure reporting question?  
Apologies if I've confused anyone, I understood it to be the latter.

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

LVL 94

Expert Comment

by:John Hurst
ID: 39795902
I made the assumption that "Month End Report" meant a report to management, and then by extension, would be financial in nature.

@damejen - Please clarify as I have not seen Month End infrastructure reporting before.

.... Thinkpads_User
LVL 25

Expert Comment

by:Diverse IT
ID: 39796291
Hi damejen,

I'm with @thinkpads_user, I'd like to know what you mean by "Month End Reporting"'s too vague.

We use a combo of RMMs consolidated into one report. But that is complicated. I think would give you a good starting point and its free. You could have a report completed in a few hours after downloading, scanning and deploying it.

Author Comment

ID: 39799426
Hi Thinkpads_User & diverseit.

My apologies, I should have been clearer in my question. Im currently a Systems Administrator and every month at the end of the month have to collate and get information on the various systems in our Server Infrastructure, Server 2008 R2, ESxi 5.1, Exchange 2007 e.c.t

I manually have to go through each system and obtain the information. I use SolarWinds and its actually quite good at obtaining allot of this information. What I was really after was something like a PS script that can be customized to my infrastructure and obtain all the information im looking for and spit it out into a work doc.
LVL 25

Accepted Solution

Diverse IT earned 500 total points
ID: 39811089
That is what Spiceworks will do...look into the Inventory section. It will grab HDD, size/changes, RAM utilization, all HW specs (including service tags & warranty info), install software w/versions, etc. and put it into PDF or Excel file.

As far as PS scripts - I don't have any that would do that. If you are specifically locked in to using a PS script maybe @thinkpads_user has something.
LVL 43

Expert Comment

ID: 39811385
LANSweeper will also do the same but I suspect Spiceworks is a better product? diverseit?

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In-place Upgrading Dirsync to Azure AD Connect
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question