Microsoft Server OS

56K

Solutions

41K

Contributors

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi EE,

I want to write a PowerShell export the contents of the following query:

openfiles /v /query  /fo CSV

Open in new window


So far I have:

$Session = New-PSSession -ComputerName SERVERNAME -ConfigurationName OpenShareFileSearch

$sb = {
    
    openfiles /v /query  /fo CSV | 
        select -skip 8 |
        ConvertFrom-Csv | 
}

Invoke-Command -Session $Session -ScriptBlock $sb |
     Export-Csv C:\temp\FileSearchResults.csv

Open in new window


I am getting the following error message:

[ict00441] Connecting to remote server failed with the following error message : The WinRM client sent a request to an
HTTP server and got a response saying the requested HTTP URL was not available. This is usually returned by a HTTP serv
er that does not support the WS-Management protocol. For more information, see the about_Remote_Troubleshooting Help to
pic.
    + CategoryInfo          : OpenError: (System.Manageme....RemoteRunspace:RemoteRunspace) [], PSRemotingTransportExc
   eption
    + FullyQualifiedErrorId : PSSessionOpenFailed
Invoke-Command : Cannot validate argument on parameter 'Session'. The argument is null or empty. Supply an argument tha
t is not null or empty and then try the command again.
At C:\temp\filename.ps1:10 char:24
+ Invoke-Command -Session <<<<  $Session -ScriptBlock $sb |
    + CategoryInfo          : InvalidData: (:) [Invoke-Command], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.PowerShell.Commands.InvokeCommandCommand

Any assistance is welcome.

Thank you.
0
Bootstrap 4: Exploring New Features
LVL 12
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

SBS 2011, admin password was changed, logged out and back into server with new password. The users are not administrators on their computers so someone with the admin password enters it when needed for an installation or download. The workstations are still able to use the old admin password, for how long I don't know but I'm assuming probably until the computer is restarted. Is there a way to avoid this?
0
We have a client with a SBS2011 (the DC) box and a 2012 terminal Server (just a member).  we are decommissioning the SBS2011 box but keeping the terminal server for the time being.  is it possible for us to remove the TS from the domain, add it to a workgroup and use local user accounts for people to login with?  the Remote licensing is installed on the terminal server itself.  the logins are just managed via the SBS box.
0
Need to find a to have summary and detail pointers in a bullet graph in sql server report builder 2008.  My data comes in for a dynamic number of model types and need to have them as a pointer within a summary of all models pointer. I have done it statically but not where model count can change depending on what our plant is building.
BufferOverviewV2.pdf
0
2
LVL 108

Expert Comment

by:John
The Windows 7 update out today and listed as an optional update fixes the invalid file handle error successfully. Requires a restart and blue screen "updating windows" message.

I have a folder mapped to my Windows 7 VM from my Windows 10 host.

Works, Fixed, Done.   At least for now.
0
LVL 27

Author Comment

by:Brian B
Thanks for summarizing the title of my post.
0
Client Computer BackupsClient Computer Backups 2Hi,
 I have Windows Server 2012 Essentials and found this unfamiliar folder C:\ServerFolders\Client Computer Backups folder occupying over 700GB of space.
 It consists of files from yesterday to April 2017 as you can see in two screenshots.
 What are these files? Who is creating these files? Can I remove them?

Thanks.
0
In order to capture all computers in the domain on the new WSUS server, should I place a WSUS GPO just under the domain (like with the default domain policy)? Would that be a bad idea?

To note, I found 145 servers in AD using powershell with only 8 of them being disabled. Since yesterday, 45 have shown up on WSUS but they are in specific OUs where I linked the WSUS GPO. The other servers are in the Computers container and Domain Controllers OU (12 DCs). So, I am about 90 off between AD and WSUS (after I link the WSUS GPO to the Domain Controllers OU).

Thanks.
0
Visual Studio 2015, SSRS

I am having a problem working on RDL files locally.  I was sent some RDL file to review.   When I use  "Add Existing"  to add the reports to a report project, I can see the report design when I right-click and select "View Designer"

However, when I select "View Code", I only see XML.  What am I doing wrong?

Thanks
0
Experts,

I have an SSRS server setup and we are currently scheduling nightly delivery (via EMAIL) of reports to clients.

The issue is that I would like to "dynamically" change the "FROM EMAIL" address for the out-going emails that contain the reports to a "Special EMAIL Address" for certain CLIENTS.
So for example, if I schedule a nightly report delivery via email for Customer "A", then I want EMAIL ADDRESS "A" to be included within the body of the email as the FROM email.

If I schedule a nightly report delivery via email for Customer "B", then I would like EMAIL ADDRESS "B" to be included within the body of the email as the FROM EMAIL.

Can someone help with HOW TO DO THIS?

Let me know if you have any questions.

Thanks
M
0
Hi, Just dropping this question again with some more detail to see if i can get a work around.

I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues. we have over 25 reports that need to been converted but they all have a running total as a grand total, typically evaluating on group, outside of the group. In some cases these running values are used in other calculations. It is a nightmare.

As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

I have read through many links but i can't see how they will work, but i might just have a skill gap, none of them cover where the running total evaluating on group are used as a total only.

I have attached an example of one of the reports that has a running total, it is only one of the possible layouts and ways the previous reports used the running totals. but does highlight the issue i am hitting. If possible i would rather do this within the ssrs report but i am at a loss on how to get it to work.

We are on SQL 2014 but are about to migrate to 2016

Any ideas on a way to get this to work?

Example-of-Running-total-in-Report.JPG
0
OWASP: Avoiding Hacker Tricks
LVL 12
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

I am doing a server refresh soon. Plan is to get replacement RDS servers running Server 2019, to replace our aging 2008R2 boxes.

Since we have a heap of software in use, I am going through the testing process, checking that everything works, and figuring what to do with apps that do not. Will then pilot with a few users for a week for acceptance testing. I have downloaded and installed a  copy of Server 2019 for this purpose.

Problem I am having now is with obtaining a key for the 2019 180day demo. The Microsoft Evaluation Centre originally had the ISO and keys on 2-Oct, but this was pulled a few days later.  Now it just says "Following the launch of Windows Server 2019, we started the process of publishing the media for the 180-day evaluation media. In the process, we found an issue with the Eval media and are in the process of fixing it." Apparently the product can be purchased, and it available to volume licensing and MSDN users, but plebs still cannot obtain a key.  The actual "issue" referred to was remedied weeks ago, and is irrelevant to us.  

Any ideas where I can obtain a 180 day key for Server 2019?

I am NOT trying to do anything dodgy, illegal or unethical here, I just want to run a demo version and see what does not work.
0
Hi Experts,

We are using Dynamics CRM 2016 on prem.  We have a subject tree built out in our CRM system that contains subject matters for Cases.

Our customer service people are in need of some reporting, and I think to get them the data they need I might need to use SSRS or Visual Studio, but if Advanced Find is an option I'm all for it because it gives them the ability to tweak their results on the fly without involving actually changing queries or reports.  Avanced find is tempting, as it will let me use the UNDER option, which is kinda cool, but I don't think it does enough.  It seems like I can only chose one subject matter at a time to report on.

Anyhow, they would like some reporting that captures each item we have listed as a subject.
They'd like this by year or by month and with a count of occurances.
So for example, I think they want something like this:

YR 2019
       Vendor Issues                     210
       Personnel Issue                    14
       Bad venue experience        45
       Guest Sickness                       6
       Complaint                             178
       Compliment                          57
        etc.


YR 2018
        Vendor Issues              196
       Personnel Issue               13
       Bad venue experience   48
       Guest Sickness               17
       Complaint                       92
       Compliment                   114
        etc.

Yr 2017
       Vendor Issues               …
0
I'm a system administrator for Report Manager.  I can see the users my folders, but cannot see the reports in the folder.  I need to be able to see all the reports created in report builder in the user's my folder.
0
I need to create a report based on a sharepoint online list. When our sharepoint server was in house, this was not a problem but I cannot get the connection string to work for sharepoint online. I do not know power BI and frankly don't have time to learn it. If I can get SSRS to connect and I can get my report done in 1/2 hour. Anyone know the connection string to make this work?
0
I am trying to write a ssrs report based on a sharepoint online list. I have tried about 100 different variations of the connection string with no luck. Can anyone point me in the right direction?
0
Hi,

I have a Windows 2012 R2 Hyper-V server with 3 VMs.  One of the VMs is setup for Remote Desktop Services and we have about 13 users connect into this server to work.  Most of them connect to it from within the office.  Some of the users connect from outside of the office.  The managers asked me if there's a way that I can restrict remote access for some of the users.  They would be able to work at their computer within the office but if they go home and feel like they want to remote into their session, they would be restricted from logging into their session when they're out of the office.  What's the best and most simple way to accomplish this?  Thanks in advance for your help!
0
I'm executing a query inside SSRS and receiving an ORA-00933: SQL command not properly ended.  It's just a SELECT statement but the error appears to be in the Where clause.  Am I specifying the parameter, @PaperBill, incorrectly?

Select ACCTUSAGE_MAIN_V.BILLING_DATE
,ACCTUSAGE_MAIN_V.BILLING_CYCE
,ACCTUSAGE_MAIN_V.BILLING_MONTH
,ACCTUSAGE_MAIN_V.BILLING_YEAR
,ACCTUSAGE_MAIN_V.INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER
,ACCTUSAGE_MAIN_V.DESCRIPTION
,ACCTUSAGE_MAIN_V.CNT_LAST_NAME
,ACCTUSAGE_MAIN_V.CNT_FIRST_NAME
,ACCTUSAGE_MAIN_V.CNT_ADDR_1
,ACCTUSAGE_MAIN_V.CNT_ADDR_2
,ACCTUSAGE_MAIN_V.CNT_CITY
,ACCTUSAGE_MAIN_V.CNT_STATE
,ACCTUSAGE_MAIN_V.CNT_ZIP
,ACCTUSAGE_MAIN_V.CNT_ZIP_EXTEN
,ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL
,ACCTUSAGE_MAIN_V.EMAIL
,ACCTUSAGE_MAIN_V.MIN_INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.MAX_INVOICE_NUMBER
From COMIT_CUSTOM.TAMU_ACCTUSAGE_MAIN_V as ACCTUSAGE_MAIN_V
Where ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL = @PaperBill
Order by ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER,ACCTUSAGE_MAIN_V.BILLING_CYCE
0
Hi,
I have opened an RDL file in Visual Studio 8, when I preview the report, I get an error message  “The selected Data Source cannot be found”.
When I go to the DataSource properties, it tells me to verify that the DataSource be included in the Project.
I do not have the rds file.

Within the Report Server Database I can see an entry for the Datasource in a table DataSource.
Is there someway I can extract this database entry into an rds file?
any guidance appreciated.
Thanks
0
We're looking for a simpler solution for controlling Windows updates on our 60 windows servers (some of which are Server 2016  which seem to have a mind of their own as to when they want to update themselves) .

As a new admin in my company, I'm working hard to learn lots of things but SCCM / ConfigMgr seems like a beast to learn.  

The desktop guy uses it for the win10 desktop update (400 users in 6 locations).  My boss doesn't want to use the same instance for servers because years ago, desktop updates were pushed to servers which trashed a bunch.

In my previous job, we used WSUS which seemed more manageable.

So, I'm looking for a simple solution for windows updates for servers without me needing to get a PHD in configmgr.

We're even open to 3rd party solutions if that would make it less painful.

I guess from a bandwidth perspective, downloading it once and updating from a local copy would be more efficient but since we just got a fatter internet connection, I'm even open to skipping that as a requirement if it would make it simpler.

Any thoughts would be very much appreciated.

Thanks,
Mike
0
OWASP: Forgery and Phishing
LVL 12
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

We currently use ADFS for authentication with some 3rd party hosted applications (i.e. Qualtrics).  When our users hit the 3rd party site, they are redirected to our ADFS site where they are prompted to enter their AD credentials.

Is it possible to get those 3rd party sites to automatically login from domain joined computers using the credentials of the logged in user instead of having the user re-enter their credentials on the ADFS site?  If so, how do we go about doing this?  Is it something we can change on the ADFS setup, or do we need the 3rd party application vendor to support it and make some changes on their end?
0
Hi Experts,

I am using SSRS and I want to create a subtotal on based on the first 7 character of the AccountID field.

So the example attached, I would have a subtotal for the account 101-002-xx,  101-007-xx and 102-002-xx.

Screenshot_1.png
0
Hi

What's the best way to failover a file server cluster? I need to take down the servers for maintenance separately but don't want any downtime.

Thanks
0
Setting up a new Hyper V environment replacing SBS 2011
I have the opportunity to do a full setup of Windows 2019 server with Exchange 2019 to replace an aging SBS 2011.
I will need a new hardware platform and look for suggestions on the best practices:
1) Should the host OS be on an SSD rather than SAS 15K ? (it will be on a RAID 1 anyway and the Hyper V VMs will be on a RAID 5 or 10 depending on suggestions))
2) Should Active directory be on a VM or a physical machine ?
3) 2 or 3 VMs planned: 1 for Exchange, one for File and print sharing and may be another one for A/D depending on suggestions to 2)
0
Hello All,

I am using the following expression to calculate percentage in SSRS,
=Format(Fields!PCTanswers.Value/100,"0%")
however, sometime the calculated values aren't equal to 100%  they are 99, so the rounding is not working correctly.
Can someone please help?  Thanks.
0
I am designing a SSRS matrix report that shows a list of people and people on their team in categories. For example

                 |CAT1      |CAT2      |CAT3
JOE           |SAM       |BILL        | MIKE
ALAN        |SAM      |ADAM     |  
DOUG      |               |BILL        |STEVE


This much works fine. But sometimes there are two people in a category for one person. So if there are 2 cat2 people for ALAN I need:

|                 |CAT1      |CAT2       |CAT3      |
|JOE           |SAM       |BILL        | MIKE      |

|ALAN        |SAM      |ADAM     |                |
|                  |              |MARK    |                |
|DOUG      |               |BILL        |STEVE     |


How do I get that textbox to expand so that it displays both values?

I am using Visual Studio 2015 and SQL Server 2016.

Here are some details that may make the question clearer. There are four tables involved. Here are the table and the relevant fields:

ManagerTable
ManagerID
ManagerName

WorkerTable
WorkerID
WorkerName
WorkerCategoryID

Category Table
CategoryID
CategoryName

ManagerWorker Table
ManagerID
Worker ID

The query results look like this:

ManagerID, ManagerName, WorkerID, WorkerName, CategoryID, CategoryName
1, JOE, 1, SAM, 1, Cat1
1. JOE, 2, BILL, 2, Cat2
1, JOE, 3, MIKE, 3, Cat3
2, ALAN, 1, SAM, 1, Cat1
2, ALAN, 4, ADAM, 2, Cat2
2, ALAN, 5, MARK, 2, Cat2
0

Microsoft Server OS

56K

Solutions

41K

Contributors

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.