Code Monkey home page Code Monkey logo

serverinventoryreport's Introduction

ServerInventoryReport

A set of scripts to create an inventory report using PowerShell, SQL and WPF

alt tag

Requirements for use

  • SQL Server
  • PowerShell V3
  • Necessary rights to pull information from remote servers
  • Necessary rights to run a scheduled task for data gathering
  • PoshRSJob module to assist with data gathering

Using the Server Inventory scripts (work in progress)

  1. Either on the SQL server or on a system that has access to the SQL server where the database and tables will reside on, run the Invoke-ServerInventorySQLBuild.ps1 script, ensuring that you have updated the SQL database location (Computername parameter on line 4).

  2. You will need to provide the account that is being used in the scheduled task the necessary rights to be able to write to the ServerInventory database that is created.

  3. You can run the Invoke-ServerInventoryDataGathering.ps1 prior to implementing it as a scheduled task to enusre that there are no access issues both with the data gathering and the shipping of data to the SQL server. Again, you will need to update the script to point to the SQL server.

  4. Once you are sure that everything looks good, you can create a scheduled task to run this script nightly or whenever you feel is appropriate.

  5. Ensure that Start-ServerInventoryUI.ps1 has been updated to point to your SQL server and also make sure that you have allowed the users that will be using the UI has read access to the database to allow the UI to populate the datatables correctly.

Using the Server Inventory UI (work in progress)

serverinventoryreport's People

Contributors

proxb avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

serverinventoryreport's Issues

sql script error - Invoke-ServerInventorySQLBuild.ps1

I got following error with "Invoke-ServerInventorySQLBuild.ps1" sql express is installed in same server
ERROR*****************
Invoke-SQLCmd : Exception calling "Open" with "0" argument(s): "A network-related or instance-specific error occurred
while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the
instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server)

consecutive date pull errors

when we run data gathering script it does complete but errors out at multiple places error message is listed below.

**************Error Message ****************
Write-Debug : The term 'Write-Debug' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling
of the name, or if a path was included, verify that the path is correct and try again.
At C:\Program Files\WindowsPowerShell\Modules\PoshRSJob\1.7.4.4\Public\Remove-RSJob.ps1:77 char:9

  •     Write-Debug "ParameterSet: $($PSCmdlet.ParameterSetName)"
    
  •     ~~~~~~~~~~~
    
    • CategoryInfo : ObjectNotFound: (Write-Debug:String) [], CommandNotFoundException
    • FullyQualifiedErrorId : CommandNotFoundException

Write-Verbose : The term 'Write-Verbose' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the
spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Program Files\WindowsPowerShell\Modules\PoshRSJob\1.7.4.4\Public\Remove-RSJob.ps1:80 char:13

  •         Write-Verbose "Adding $($PSBoundParameters[$Property])"
    
  •         ~~~~~~~~~~~~~
    
    • CategoryInfo : ObjectNotFound: (Write-Verbose:String) [], CommandNotFoundException
    • FullyQualifiedErrorId : CommandNotFoundException

END******************

Service tab empty

The service tab per server is empty, some bug in Invoke-ServerInventoryDataGathering.ps1 ???
The table was created but nothing there
Thanks

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.