Microsoft Server OS

57K

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,

If I have 2 WSUS servers, one is the main server and the second is the downstream server (replicate) then how client knows which one it should talk to?

Thanks
0
Bootstrap 4: Exploring New Features
LVL 13
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.

Hi:

I continue to have issues, with this SSRS report.  I have entered five cases, here in experts-exchange, on this.

Now, I'm getting an error on the main report saying that the "Subreport could not be shown".

Last week, the subreport's data appeared just fine.  This week, it does not.

What would cause this issue?

Thanks!

John
0
I need assistance with the following requirements:

I need the font on my text to equal "DimGray" when IsRunning = "Processing" else if the MostRecent.Value > today = Red else Green. With what I have below, its making them all DimGray.

=Switch(Fields!IsRunning.Value ="Processing" , "DimGray", IIF(Fields!MostRecent.Value
>= TODAY(), "GREEN", "RED"))
0
How do I translate a cn= (either common name or cannoical name, not sure) into the actual users name so I can find out which user is causing this error

from Event Log Below:  Mapi session /o="Company Name"/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=e42d9331822a4587b26c214a3ccb4dbc with client type MoMT exceeded the maximum of 500 objects of type Folder.

How would I find which user is cn=e42d9331822a4587b26c214a3ccb4dbc  

Can be using Powershell, dsquery or any other tool / method.

Log Name:      Application
Source:        MSExchangeIS
Date:          10/4/2019 9:24:46 AM
Event ID:      9646
Task Category: MAPI
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      <SERVER NAME>
Description:
Mapi session /o="Company Name"/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=e42d9331822a4587b26c214a3ccb4dbc with client type MoMT exceeded the maximum of 500 objects of type Folder.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSExchangeIS" />
    <EventID Qualifiers="49156">9646</EventID>
    <Level>2</Level>
    <Task>6</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2019-10-04T13:24:46.000000000Z" />
    <EventRecordID>9822389</EventRecordID>
    <Channel>Application</Channel>
    <Computer>"COMPUTER NAME"</Computer>
    <Security />
  </System>
  <EventData>
    …
0
I just now implemented a simple filter saying that cost should not be equal to 0.  Now, SSRS is giving me an error saying that it "cannot compare data of types system.decimal and system.double".

Thoughts?
0
In SSRS, I want to filter out only those employees with more than 1 partfile number.  

My query is

Select e.name,
            p.pfnumber from employees as e
left join partfile as p
on p.recid=e.partfilerecid
group by e.name

What expression do I use in the filter to be > 1?
0
Hi,
I need to install Dell R510 with the OS Win Server 2019.
Per suggestion one of the Expert of EE, I have to download the BIOS of a Dell machine R710.

I am not sure here; I have a Dell server R720; is it workable?
I have already EXTRACT the Bios of R720 into a USB Stick.

I have here with me the OS of Windows 2012, 2016 and 2019.

I am still confused here:
I will try to install the OS at R510 by deploying the OS;
I will put The Windows 2012 OS; then, where can I INSERT the above USB stick which has the BIOS of R720 in it? What key should I press or select?

Is there any other driver should I download from Machine R720?

Thanks,
tjie
0
Good day,

I am in the process of migrating my entire network to a new domain. There is a trust relationship between the old and new domain. I have also kept usernames and group names the same as well as migrated SID across to new domain. When migrating my file server to new domain, all permissions are still intact as it was on old domain. How do I keep the permissions the same and just change the domain name from old to new, i.e. olddomain\group1 to newdomain\group1 on all folders, subfolders and files? I have SubInACL but have never used it before and don't know the commands.

Also, is it wise to migrate the SID's across to the new domain?
0
Hi, the time on our Server 2012 R2 keeps changing a few minutes ahead. It should be setup for NTP.
0
Lenovo TD340 server 2012, purchased in 2015, my customer needs to upgrade in place to server 2019 to continue to get support from our app vendors.
My supplier says Lenovo TD340 does not support server 2016 or 2019.
0
Fundamentals of JavaScript
LVL 13
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

I am trying to write a SQL statement whereby I have a field named FormElementReference, which is the name of the question, and an associated field called value which holds the answer to that question.

I've written a case statement to try and achieve this, and store the separate values in separate fields for export to SSRS.

What I currently get is an row for each answer value.

Screenshot showing SQL with a row for each value.
SELECT DISTINCT
  FormResults.FormResultKey AS [FormResults FormResultKey]
  ,FormResults.FormID
  ,FormResults.FormReference
  ,UserForename + ' ' + UserSurname as [Full Name]
  ,FormResults.FormResultDate
 
 

,CASE WHEN FormResultDetails.FormElementReference = 'Date' then value else null end AS JobDATE
,CASE WHEN FormResultDetails.FormElementReference = 'Time' then value else null end AS TIMEFrom
,CASE WHEN FormResultDetails.FormElementReference = 'TEB' then value else null end AS TIMETo
,CASE WHEN FormResultDetails.FormElementReference = 'TEA' then value else null end AS TotalWorked
,CASE WHEN FormResultDetails.FormElementReference = 'JNO' then value else null end AS JobNumbers
,CASE WHEN FormResultDetails.FormElementReference = 'AA' then value else null end AS JobAddress
,CASE WHEN FormResultDetails.FormElementReference = 'Reason' then value else null end AS JobReason
,CASE WHEN FormResultDetails.FormElementReference = 'Managers' then value else null end AS ManagerAuthorised


FROM
  FormResultAnswers
  LEFT OUTER JOIN Documents
    ON …
0
Hello:

In SQL Reporting Services (SSRS), I have an "If, Then" formula shown in the first of two formulas pasted below.

I have this formula as an "expression" in a cell.  I want to multiply this cell times a value in another cell and have the product (multiplication result) appear in another cell.  I keep getting an error message that does not explain itself.  But, the error is clearly letting me know that I;'m not doing this correctly.

Specifically, I'm trying to tell SSRS to multiply this formula times another field.

This other field contains the second formula pasted below.

What formula do I use to accomplish this multiplication?

Thank you!

John


=If(sum(Fields!TRXQTY.Value)=0,0,sum(Fields!DEBITAMT.Value-Fields!CRDTAMNT.Value))
/ IIF(sum(Fields!TRXQTY.Value)=0,1,sum(Fields!TRXQTY.Value))


=Sum(Fields!TRXQTY.Value*(Fields!DEBITAMT.Value-Fields!CRDTAMNT.Value))
0
I'm unable to create an OU in Active Directory, it says that an OU with that name is already in use.  I did a search for this OU at the top level of domain no results.  I created this OU last night on secondary DC it never propagated over to primary.  Came in this morning secondary DC had "Pending Status" assuming it was from the newly created OU last night,  unable to get rid of Pending status without a reboot.  Now even though OU doesn't exist it thinks it does.  How can i clear this up?
0
Hello Everybody and have a wonderful day,

Could you please shed more light on the Microsoft Assessment and Planning Toolkit (part of the Microsoft Solution Accelerators) for inventory and performance information. Is this Tool/Product still a viable solution to use or there is/are a new product/s?

Thanks in advance
0
We are trying to track down an issue where the password expiration date is not conforming to our policy.  We have a 90 policy, but the password on domain accounts seem to be expiring at 42 days.  

The following net user command provides the expected output:
>net user /domain joe.user
The request will be processed at a domain controller for domain example.com.
User name                    joe.user
Full Name                    Joe User
Comment
User's comment
Country/region code          000 (System Default)
Account active               Yes
Account expires              Never

Password last set            8/1/2019 9:09:56 AM
Password expires             10/30/2019 9:09:56 AM
Password changeable          8/2/2019 9:09:56 AM
Password required            Yes
User may change password     Yes
.....

Open in new window

The 10/30/2019 date corresponds with the 90 day requirement.  However, the password expires much sooner.  Using the following get-aduser command, you get a different date:
(Get-ADUser -Identity joe.user -Properties msDS-UserPasswordExpiryTimeComputed).'msDS-UserPasswordExpiryTimeComputed' |ForEach-Object -Process {[datetime]::FromFileTime($_)}

Thursday, September 12, 2019 9:09:56 AM

Open in new window

The dates provided by the two commands are different.  Any insight why, it may help use narrow down the issue if we knew why the two commands return different dates?  Also, the account really does expire earlier than the 90 policy.  We've had users needing to change their password even though the net user command shows they have plenty of time.
0
Hi:

Attached is my main report, along with its subreport.

As you may be able to see in the screenshot, I need a subtotal based on account number (the first column).

The subtotal needs to be by the extended cost, which is the "Ext" column of the main report.  This column represents extended cost.

I have produced this total in the subreport.  But, I cannot tell where to place it on the main report to generate the subtotal.

If you have any thoughts at all, please share them.  Even the "littlest" idea will help.

Thank you!

John




Historical-Inventory-Trial-Balance-S.rdl
Extended-Cost-by-Account-Number.rdl
Screenshot
0
We have a number of reports that run out of our batch system behind data loads. There have been some recent updates. Previously, we have only one account type, so the parameter was just a single-value text value. We now use a multi-select parameter, and am getting an error when we attempt to run in batch although it runs properly through the web interface. I've captured the command line from our batch system:
\\xxx.com\share\CM\DEV\OPS\Apps\SSRSReportBuild\SSRSReportBuild.exe "Report=Solutions/ZZ-XX-12345-AccountAuditReport" "FileName=FCT-ZZ-XX-12345-AccountAuditReport.rdl" "MaxRunTime=1800" "Path=\\rpt2webtest\MFTest" "pAcctType=ABC,XYZ" "pAcctTypeList=ABC,XYZ" "pRunDate=20190906" "pRunType=D" "Render_Format=EXCEL"

Open in new window

When executed, the job fails with this error:
System.Web.Services.Protocols.SoapException: This report requires a default or user-defined value for the report parameter 'pAcctType'. To run or subscribe to this report, you must provide a parameter value.

Open in new window

Any suggestions of how to correct this and properly pass the value for pAcctType, a multi-value parameter?

Some of the questions that might come up
  • The source of available values for the multi-select parameter in the report is a SQL query.
  • The values 'ABC' and 'XYZ' do exist in the data.
  • We cannot pass the same parameter name twice on the command line, as the API does not allow this and will generate and error (I mention this becasue some web searching I've done indicate that is how you pass multi-select values in the web interface (e.g. &pAcctType=ABC&pAcctType=XYZ...)
0
is PowerShell get-hotfix command a reliable way to determine that last windows security update applied to a windows server/client? I have used it on a sample of servers and it seems to sort the results into a sequential order although some seem a little but out of order so to speak, I've picked that the last value in the sequence and then gone online using the KB number, e.g. KB4499151 - to determine the date is was released/issued by Microsoft. Is this an accurate way to determine the last date an update was applied.
0
I'm having trouble with my internal SMTP mail relay. A user had some malware and we were flagged as spammers. Now SSRS email does not work. I have loads of stuff that uses the internal mail relay but am slowly going through and changing things but am stuck on SSRS

The only options I have within SSRS Config Manager are :

Sender Address:
Current SMTP Method: (set to 'Use SMTP Server' but greyed out)
SMTP Server: (This has IP address of internal mail relay)

Does anyone know how to get this to work with an external SMTP server?
0
CompTIA Network+
LVL 13
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

repadmin-output.txtDestination server is currently rejecting replication requests.  Mixed OS DC environment.  Destination server is 2008 R2 and was originally the certificate store.  Attempted to move Store to a 2012 server.  after removing Store, we went for DCpromo, but the process would not complete.  We restored the Store to original location, but are experiencing multiple cert failures.  Please Help!  I'm pretty sure I did something wrong with the Certificate server, but don't know where to start.
0
I have a new fileserver, to host the home folder for domain users.
For the users$ root folder the administrator group of the fileserver and the system has full control for this folder, subfolders, and files and the Creator Owner Full control to subfolders and files only.
When I created a user with the GUI of active directory, it creates a folder for the user under users$ folder, on this new folder, inhered the rights from users$ folder and add full rights for the new user.
When this new user login the system creates two new folders Desktop and Documents but these two new folders only the user and System has rights, the administrator doesn't have any right, I cannot check the permissions.
Any idea of how to allow enable inheritance to this folder. Administrators group needs to have rights to access the Desktop and Documents folder.
Note, this problem is also present in the old fileserver.
0
0
I am in the midst of migrating a heap of data from an old 2008R2 server to a new 2019 server.

At the moment I am verifying file counts and sizes.

There are some folders with restricted security. These all have Administrators granted full control. I am a domain admin, and member of the Administrators group.

On the source server, running 2008R2, this means I have access to those files, by virtue of this group membership, as expected.

On the 2019 server I have moved files too, this is not the case however:
If I click on the folder, I get a message stating "You don't currently have permission to access this folder Click continue to permanently get access to this folder". If I click continue, sure enough, my account name is added to the list of user who have full access, and I can read files. I really don't want to add my account to a heap of directories that I already have access too.
If I right click on the folder, I see 0 files listed. Clicking on Security, Advanced, Effective access and running the Effective Access wizard confirms I have full access.

I have tried running C:\Windows\Explorer are as administrator, but that does nothing.

How to I get Server 2019 to just allow me to access these files, which I supposedly already have access too, without rewriting permissions?
0
I am trying to see if I can get rid of our on prem AD server.  We have a subscription for Azure active directory P1.  It seems like I can connect everybody in the organization to that active directory and then set policies from the portal. For our file server I can simply use SharePoint. Is there any reason I would need to keep an on prem server since I’m not really using it for more than that.  I am using it as a  DHCP server and DNS server. But I can simply have our sonic wall do all that.
0
I need to link and additional table to filter by the plant in doing so create multiple records for each entry. I am looking to just get the first entry for one.

SELECT 
    OrderHead.CreditOverride, 
    OrderHead.OpenOrder, Customer.CreditHold, 
    OrderHead.OrderNum, Customer.Name, 
    OrderHead.EntryPerson, OrderHead.OrderDate, 
    Customer.TermsCode, OrderHead.ShipToCustNum, OrderRel.Plant
FROM  
    Customer 
INNER JOIN
    OrderHead ON Customer.Company = OrderHead.Company 
             AND Customer.CustNum = OrderHead.BTCustNum 
INNER JOIN
    OrderRel ON OrderHead.OrderNum = OrderRel.OrderNum
WHERE 
    (OrderHead.CreditOverride = 0) 
    AND (OrderHead.OpenOrder = 1)  
    AND (Customer.CreditHold = 1) 
    AND (OrderRel.Plant = 'mfgsys')
Trying to grab the first unique record from orderhead.

Open in new window


2019-08-25_14-25-15-p1.pdf

it doubles up my entries   i know but i only want to see the first order number for each one.
0