Solved

Month End Reporting

Posted on 2014-01-15
11
311 Views
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.

Thanks.
0
Comment
Question by:damejen
  • 3
  • 2
  • 2
  • +1
11 Comments
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
ID: 39795804
Please have a look at LANSweeper http://www.lansweeper.com/  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.
0
 
LVL 93

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
0
 
LVL 42

Expert Comment

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

Rob
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 93

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
0
 
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" too...it's too vague.

We use a combo of RMMs consolidated into one report. But that is complicated. I think http://www.spiceworks.com/network-management/ 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.
0
 

Author Comment

by:damejen
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.
0
 
LVL 25

Accepted Solution

by:
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.
0
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
ID: 39811385
LANSweeper will also do the same but I suspect Spiceworks is a better product? diverseit?
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Utilizing an array to gracefully append to a list of EmailAddresses
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

825 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